DBA Data[Home] [Help]

APPS.XLA_RETRIVE_CCID_PKG dependencies on XLA_AE_HEADERS

Line 221: FROM xla_ae_headers

217: SELECT code_combination_id
218: FROM xla_ae_lines
219: WHERE ae_header_id IN (
220: SELECT ae_header_id
221: FROM xla_ae_headers
222: WHERE accounting_batch_id = p_acc_batch_id
223: AND application_id = p_application_id
224: AND ledger_id = g_seq_context_value (i)));
225:

Line 248: FROM xla_ae_headers

244: FOR i IN g_seq_context_value.FIRST .. g_seq_context_value.LAST
245: LOOP
246: SELECT NVL (MAX (ROWNUM), 0)
247: INTO l_rec_count
248: FROM xla_ae_headers
249: WHERE accounting_batch_id = p_acc_batch_id
250: AND application_id = p_application_id
251: AND ledger_id = g_seq_context_value (i);
252:

Line 275: FROM xla_ae_headers

271: SELECT code_combination_id
272: FROM xla_ae_lines
273: WHERE ae_header_id IN (
274: SELECT ae_header_id
275: FROM xla_ae_headers
276: WHERE accounting_batch_id =
277: p_acc_batch_id
278: AND application_id =
279: p_application_id

Line 806: FROM xla_ae_headers

802: SELECT code_combination_id
803: FROM xla_ae_lines
804: WHERE ae_header_id IN (
805: SELECT ae_header_id
806: FROM xla_ae_headers
807: WHERE accounting_batch_id =
808: p_acc_batch_id
809: AND application_id = p_application_id
810: AND ledger_id = p_ledger_id))) e

Line 920: FROM xla_ae_headers

916: SELECT code_combination_id
917: FROM xla_ae_lines
918: WHERE ae_header_id IN (
919: SELECT ae_header_id
920: FROM xla_ae_headers
921: WHERE accounting_batch_id =
922: p_acc_batch_id
923: AND application_id = p_application_id
924: AND ledger_id = p_ledger_id))) e;