DBA Data[Home] [Help]

APPS.GL_GLXRLHST_XMLP_PKG SQL Statements

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

Line: 45

    select enable_average_balances_flag
    into AVERAGE_BALANCES_FLAG
    from gl_ledgers
    where ledger_id = P_LEDGER_ID;
Line: 54

    SELECT effective_period_num
    INTO   FROM_EFF_PERIOD_NUM
    FROM   gl_period_statuses
    WHERE  application_id = 101
    AND    ledger_id = P_LEDGER_ID
    AND    period_name = P_FROM_PERIOD;
Line: 61

    SELECT effective_period_num
    INTO   TO_EFF_PERIOD_NUM
    FROM   gl_period_statuses
    WHERE  application_id = 101
    AND    ledger_id = P_LEDGER_ID
    AND    period_name = P_TO_PERIOD;
Line: 156

 Function FLEX_SELECT_ALL_p return varchar2 is
	Begin
	 return FLEX_SELECT_ALL;
Line: 164

 Function FLEX_SELECT_BAL_p return varchar2 is
	Begin
	 return FLEX_SELECT_BAL;
Line: 172

 Function FLEX_SELECT_ACCT_p return varchar2 is
	Begin
	 return FLEX_SELECT_ACCT;