APPS.GL_GLXUSA_XMLP_PKG dependencies on GL_CONSOLIDATION_ACCOUNTS

Line 169: P2 := ' FROM gl_consolidation_accounts CONS_ACCT, ';

165:
166:
167:
168: P1 := ' EXISTS ( SELECT sysdate ' ;
169: P2 := ' FROM gl_consolidation_accounts CONS_ACCT, ';
170: P3 := ' gl_consolidation_history GLH ';
171: P4 := ' WHERE GLH.consolidation_id = :P_CONSOLIDATION_ID ' ;
172: P5 := ' AND GLH.from_period_name = :P_PERIOD_NAME ';
173: P6 := ' AND GLH.average_consolidation_flag = :P_N ';

Line 342: FROM GL_CONSOLIDATION_ACCOUNTS CA

338: records_present out nocopy varchar2
339: ) is
340: begin
341: SELECT 'Y' INTO P_Accounts_Clause
342: FROM GL_CONSOLIDATION_ACCOUNTS CA
343: WHERE CA.consolidation_id = cons_id
344: AND CA.consolidation_run_id =
345: ( SELECT max(CH.consolidation_run_id)
346: FROM GL_CONSOLIDATION_HISTORY CH