APPS.GMS_FUNDS_CONTROL_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 2237: psa_bc_xla_events_gt xlaevt,

2233: NULL, -- burdenable_raw_cost
2234: pobc.reference6, -- For GMSIP
2235: pobc.reference13 --Vendor id for GMSIP transactions
2236: FROM po_bc_distributions pobc ,
2237: psa_bc_xla_events_gt xlaevt,
2238: pa_expenditure_types et,
2239: gms_project_types gpt,
2240: pa_projects_all pp
2241: WHERE pobc.ae_event_id = xlaevt.event_id

Line 2256: FROM psa_bc_xla_events_gt xlaevt,

2252: apd.line_type_lookup_code */
2253: /* Added for Bug 5645290 */
2254: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2255: /* Bug 5645290 - End */
2256: FROM psa_bc_xla_events_gt xlaevt,
2257: ap_invoice_distributions_all apd,
2258: gms_project_types gpt,
2259: pa_projects_all pp,
2260: ap_invoices_all apinv

Line 2349: AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt)

2345: NULL inv_dist_reference_2,
2346: NULL ap_prepay_app_dist_id
2347: FROM ap_extract_invoice_dtls_bc_v apext -- Bug 5500126
2348: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2349: AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt)
2350: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2351: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2352: -- validation.
2353: /* Commenting the following condition for Bug 5645290

Line 2411: and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)

2407: AND APPH.prepay_history_id = APAD.prepay_history_id
2408: AND AID.invoice_line_number = AIL.line_number
2409: AND AID.invoice_id = AIL.invoice_id
2410: AND AID.line_type_lookup_code IN ( 'PREPAY' ,'NONREC_TAX' ) --Bug 5490378
2411: and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)
2412: and AID.invoice_distribution_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2413: AND p_prepay_exists = 'Y'
2414: and aid.invoice_distribution_id = apad.prepay_app_distribution_id
2415: and APAD.PREPAY_DIST_LOOKUP_CODE <> 'AWT';

Line 8830: FROM PSA_BC_XLA_EVENTS_GT

8826: result_code = 'F22'
8827: WHERE status_code in ('I','A','S')
8828: AND source_event_id IN
8829: (SELECT event_id
8830: FROM PSA_BC_XLA_EVENTS_GT
8831: WHERE upper(result_code) in ('XLA_ERROR','FATAL'));
8832:
8833: END TIEBACK_FAILED_ACCT_STATUS;
8834: