APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on XLA_AE_HEADERS

Line 431: l_upg_batch_id XLA_AE_HEADERS.Upg_Batch_Id%TYPE := -99;

427: l_prepay_hist_id AP_PREPAY_HISTORY_ALL.Prepay_History_id%TYPE := -99;
428: l_accounting_event_id XLA_EVENTS.event_id%TYPE := -99;
429: l_historical_flag AP_PREPAY_HISTORY_ALL.Historical_flag%TYPE := 'N';
430: l_posted_flag AP_PREPAY_HISTORY_ALL.Posted_flag%TYPE := 'N';
431: l_upg_batch_id XLA_AE_HEADERS.Upg_Batch_Id%TYPE := -99;
432:
433: l_curr_calling_sequence VARCHAR2(2000);
434: l_total_paid_amt NUMBER;
435: l_final_payment BOOLEAN := FALSE;

Line 471: xla_ae_headers xah,

467: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
468: SELECT SUM(amount), count(1)
469: FROM ap_invoice_distributions_all aid,
470: xla_events evnt,
471: xla_ae_headers xah,
472: ap_system_parameters_all asp
473: WHERE aid.accounting_event_id = p_acct_event_id
474: AND aid.accounting_event_id = evnt.event_id
475: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',

Line 552: xla_ae_headers XAH,

548: l_posted_flag,
549: l_historical_flag,
550: l_upg_batch_id
551: FROM ap_prepay_history_all APPH,
552: xla_ae_headers XAH,
553: ap_system_parameters_all ASP
554: WHERE APPH.Invoice_ID = P_Invoice_ID
555: AND APPH.accounting_event_id = l_prepay_hist_rec.related_prepay_app_event_id
556: AND XAH.application_id = 200

Line 763: -- XLA_AE_Headers XAH

759: --WHERE Invoice_ID = p_invoice_id
760: --AND EXISTS (SELECT 'Upg Payment'
761: -- FROM AP_Payment_History_All APH,
762: -- AP_System_Parameters_All ASP,
763: -- XLA_AE_Headers XAH
764: -- WHERE APH.Check_ID = AIP.Check_ID
765: -- AND APH.Historical_Flag = 'Y'
766: -- AND APH.Posted_Flag = 'Y'
767: -- AND APH.Org_id = ASP.Org_id

Line 784: -- XLA_AE_Headers XAH

780: -- commenting below for bug10183934
781: --SELECT count(*)
782: -- INTO l_upg_prepay_app
783: -- FROM AP_Invoice_Distributions_ALL AID,
784: -- XLA_AE_Headers XAH
785: -- WHERE AID.accounting_event_id = XAH.Event_ID
786: -- AND XAH.Application_ID = 200
787: -- AND XAH.Event_type_Code IN ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
788: -- AND XAH.Upg_batch_ID IS NOT NULL

Line 3133: FROM xla_ae_headers aeh,

3129: DELETE FROM xla_distribution_links
3130: WHERE application_id = 200
3131: AND ae_header_id IN
3132: (SELECT ae_header_id
3133: FROM xla_ae_headers aeh,
3134: ap_prepay_history_all aph
3135: WHERE aeh.event_id = aph.accounting_event_id
3136: AND aph.accounting_event_id = p_accounting_event_id
3137: AND aph.invoice_id = p_invoice_id

Line 3422: XLA_AE_Headers AEH,

3418: XLA_Transaction_Entities_upg XTE,
3419: XLA_Events XLE,
3420: AP_Prepay_App_Dists APAD,
3421: AP_Invoice_Distributions_All AID,
3422: XLA_AE_Headers AEH,
3423: XLA_AE_Lines AEL
3424: WHERE XLE.event_id = p_accounting_event_id
3425: AND AI.Org_Id = ASP.Org_Id
3426: AND AI.Invoice_ID = AID.Invoice_ID

Line 3524: XLA_AE_Headers AEH,

3520: XLA_Transaction_Entities_upg XTE,
3521: XLA_Events XLE,
3522: AP_Prepay_App_Dists APAD,
3523: AP_Invoice_Distributions_All AID,
3524: XLA_AE_Headers AEH,
3525: XLA_AE_Lines AEL
3526: WHERE XLE.event_id = p_accounting_event_id
3527: AND AI.Org_Id = ASP.Org_id
3528: AND AI.Invoice_ID = AID.Invoice_ID