APPS.GL_GLYRLBGE_XMLP_PKG SQL Statements

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

Line: 27

SELECT NAME, CHART_OF_ACCOUNTS_ID
INTO ACCESS_NAME, STRUCT_NUM
FROM GL_ACCESS_SETS
WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;

Line: 174

    select name, chart_of_accounts_id, currency_code
    into ledgername, coaid, func_curr
    from gl_ledgers
    where ledger_id = ledgerid;

Line: 194

    SELECT  a.period_name
    INTO    tfirst_period
    FROM    gl_period_statuses a, gl_period_statuses b
    WHERE   a.application_id = 101
    AND     b.application_id = 101
    AND     a.ledger_id = tledger_id
    AND     b.ledger_id = tledger_id
    AND     a.period_type = b.period_type
    AND     a.period_year = b.period_year
    AND     b.period_name = tperiod_name
    AND     a.period_num =
     (SELECT min(c.period_num)
                   FROM gl_period_statuses c
             WHERE c.application_id = 101
               AND c.ledger_id = tledger_id
               AND c.period_year = a.period_year
               AND c.period_type = a.period_type
          GROUP BY c.period_year);

Line: 402

 Function BEGIN_CR_SELECT_p return varchar2 is
	Begin
	 return BEGIN_CR_SELECT;

Line: 414

 Function BEGIN_DR_SELECT_p return varchar2 is
	Begin
	 return BEGIN_DR_SELECT;

Line: 418

 Function END_DR_SELECT_p return varchar2 is
	Begin
	 return END_DR_SELECT;

Line: 446

 Function PER_DR_SELECT_p return varchar2 is
	Begin
	 return PER_DR_SELECT;

Line: 454

 Function END_CR_SELECT_p return varchar2 is
	Begin
	 return END_CR_SELECT;

Line: 458

 Function PER_CR_SELECT_p return varchar2 is
	Begin
	 return PER_CR_SELECT;