APPS.GL_GLXUSA_XMLP_PKG dependencies on GL_CONSOLIDATION

Line 119: FROM gl_ledger_relationships glr, gl_consolidation gcs

115:
116: begin
117: SELECT glr.target_ledger_name
118: INTO SubsidLedgerName
119: FROM gl_ledger_relationships glr, gl_consolidation gcs
120: WHERE glr.target_currency_code = gcs.from_currency_code
121: AND glr.source_ledger_id = gcs.from_ledger_id
122: AND glr.target_ledger_id = gcs.from_ledger_id
123: AND gcs.consolidation_id = P_CONSOLIDATION_ID;

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 170: P3 := ' gl_consolidation_history GLH ';

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 ';
174: P7 := ' AND GLH.actual_flag = :P_A ';

Line 179: P10_3:=' FROM GL_CONSOLIDATION_HISTORY GLH2 ';

175: P8 := ' AND GLH.amount_type = :P_PERIOD_TYPE ';
176: P9 := ' AND GLH.consolidation_run_id = CONS_ACCT.consolidation_run_id ';
177: P10_1:=' AND GLH.consolidation_run_id = ';
178: P10_2:=' (SELECT MAX(glh2.consolidation_run_id) ';
179: P10_3:=' FROM GL_CONSOLIDATION_HISTORY GLH2 ';
180: P10_4:=' WHERE glh2.consolidation_id = GLH.consolidation_id ';
181: P10_5:=' AND glh2.from_period_name = GLH.from_period_name ';
182: P10_6:=' AND glh2.actual_flag = GLH.actual_flag ';
183: P10_7:=' AND glh2.amount_type = GLH.amount_type) ';

Line 324: from gl_consolidation glc

320: glc.from_ledger_id, glc.to_ledger_id,
321: glc.description
322: into cons_name, method, curr_code, from_ledid, to_ledid,
323: description
324: from gl_consolidation glc
325: where glc.consolidation_id = cons_id;
326:
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN

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

Line 346: FROM GL_CONSOLIDATION_HISTORY CH

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
347: WHERE CH.consolidation_id = cons_id
348: AND CH.average_consolidation_flag = avg_flag
349: AND CH.actual_flag = actual_flag
350: AND CH.amount_type = amount_type )