DBA Data[Home] [Help]

APPS.AP_APXTRSWP_XMLP_PKG dependencies on XLA_AE_HEADERS

Line 432: FROM xla_ae_headers xah, xla_transaction_entities xte

428:
429: -- Bug 3739324 - Replaced AP table with XLA table
430: SELECT COUNT(*)
431: INTO cut_counter
432: FROM xla_ae_headers xah, xla_transaction_entities xte
433: WHERE xah.accounting_date BETWEEN p_start_date AND p_end_date
434: AND xah.gl_transfer_status_code = 'N'
435: AND xah.entity_id = xte.entity_id
436: AND xte.security_id_int_1 = co_org_id

Line 1075: FROM xla_ae_headers xah, xla_transaction_entities xte

1071: AND rownum = 1;
1072:
1073: SELECT COUNT(*)
1074: INTO cut_counter
1075: FROM xla_ae_headers xah, xla_transaction_entities xte
1076: WHERE xah.accounting_date BETWEEN p_start_date AND p_end_date
1077: AND xah.gl_transfer_status_code = 'N'
1078: AND xah.entity_id = xte.entity_id
1079: AND xte.security_id_int_1 = co_org_id

Line 1271: FROM xla_ae_headers --Bug 3739324

1267: AND rownum = 1;
1268:
1269: SELECT COUNT(*)
1270: INTO cut_counter
1271: FROM xla_ae_headers --Bug 3739324
1272: WHERE accounting_date BETWEEN p_start_date AND p_end_date
1273: AND gl_transfer_status_code = 'N'
1274: AND ledger_id = p_set_of_books_id
1275: AND rownum = 1;