DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 163: -- index XLA_TRANSACTION_ENTITIES_N1

159: l_org_id NUMBER;
160:
161: -- bug13114217, added join with AP_INVOICES_ALL
162: -- changed the join conditions for XTE to pick up
163: -- index XLA_TRANSACTION_ENTITIES_N1
164: --
165: CURSOR c_get_unprocessed_events IS
166: SELECT xla.event_id
167: FROM xla_events xla,

Line 168: xla_transaction_entities xte,

164: --
165: CURSOR c_get_unprocessed_events IS
166: SELECT xla.event_id
167: FROM xla_events xla,
168: xla_transaction_entities xte,
169: ap_invoices_all ai
170: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
171: AND xla.application_id = 200
172: AND xte.application_id = 200