GL: Standard function to get the CCID from a combination of segments

The below query is used to get the code_combination_id from combination of segments you have in the General Ledger.

SELECT fnd_flex_ext.get_ccid ('SQLGL',
                              'GL#',
                              101,
                              fnd_date.date_to_canonical (SYSDATE),
                              '1-5105-521202-0000-0000-0000-0000-0000'
                             )
  FROM DUAL;