APPS.GL_GLRGNJ_XMLP_PKG SQL Statements

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

Line: 5

      SELECT PERIOD_NAME
      FROM GL_PERIODS
      WHERE PERIOD_SET_NAME = T_PERIOD_SET_NAME
      AND END_DATE = T_END_DATE
      ORDER BY PERIOD_NUM DESC;

Line: 11

      SELECT PERIOD_NAME
      FROM GL_PERIODS
      WHERE PERIOD_SET_NAME = T_PERIOD_SET_NAME
      AND START_DATE = T_START_DATE
      ORDER BY PERIOD_NUM DESC;

Line: 28

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

Line: 46

     POSTING_STATUS_SELECT := 'J.reference_4';

Line: 48

     POSTING_STATUS_SELECT := 'J.reference_1';

Line: 103

      SELECT name, object_type_code, consolidation_ledger_flag
      INTO   PARAM_LEDGER_NAME, 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
      WHERE rownum = 1;

Line: 140

    SELECT USER_JE_SOURCE_NAME
    INTO JE_USER_SOURCE_DSP
    FROM GL_JE_SOURCES
    WHERE JE_SOURCE_NAME =  P_JE_SOURCE_NAME;

Line: 147

     SELECT min(a.start_date),max(a.end_date)
     INTO   t_p_start_date, t_p_end_date
     FROM   gl_period_statuses a,
            gl_access_set_assignments b
     WHERE  b.access_set_id = p_access_set_id
     AND    a.application_id = 101
     AND    a.closing_status <> 'N'
     AND    a.ledger_id = b.ledger_id;

Line: 156

     SELECT min(a.start_date),max(a.end_date)
     INTO   t_p_start_date, t_p_end_date
     FROM   gl_period_statuses a,
            gl_ledger_set_assignments b
     WHERE  b.ledger_set_id = p_ledger_id
     AND    a.application_id = 101
     AND    a.closing_status <> 'N'
     AND    a.ledger_id = b.ledger_id;

Line: 165

     SELECT min(start_date),max(end_date)
     INTO   t_p_start_date, t_p_end_date
     FROM   gl_period_statuses
     WHERE  application_id = 101
     AND    ledger_id = p_ledger_id
     AND    closing_status <> 'N';

Line: 232

 Function POSTING_STATUS_SELECT_p return varchar2 is
	Begin
	 return POSTING_STATUS_SELECT;