APPS.GL_GLRFGNJ_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

    SELECT name, chart_of_accounts_id
    INTO   ACCESS_SET_NAME, STRUCT_NUM
    FROM   gl_access_sets
    WHERE  access_set_id = P_ACCESS_SET_ID;

Line: 53

     POSTING_STATUS_SELECT := 'J.reference_4';

Line: 55

     POSTING_STATUS_SELECT := 'J.reference_1';

Line: 104

      SELECT name, currency_code, object_type_code, consolidation_ledger_flag
      INTO   PARAM_LEDGER_NAME, PARAM_LEDGER_CURR,
             PARAM_LEDGER_TYPE, CONSOLIDATION_LEDGER_FLAG
      FROM   gl_ledgers
      WHERE  ledger_id = P_LEDGER_ID;

Line: 127

      SELECT consolidation_ledger_flag
      INTO CONSOLIDATION_LEDGER_FLAG
      FROM gl_system_usages;

Line: 139

      SELECT substr(ltrim(to_char(11, '9G9')), 2, 1)
      INTO   THOUSANDS_SEPARATOR
      FROM   dual;

Line: 211

 Function POSTING_STATUS_SELECT_p return varchar2 is
	Begin
	 return POSTING_STATUS_SELECT;