APPS.AP_XLA_UPGRADE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 778: 'Insert into ap_payment_hist_dists');

774: END IF;
775:
776: IF g_level_procedure >= g_current_runtime_level THEN
777: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PAYMENT_DIST_LINKS',
778: 'Insert into ap_payment_hist_dists');
779: END IF;
780:
781: INSERT INTO ap_payment_hist_dists
782: (PAYMENT_HIST_DIST_ID,

Line 781: INSERT INTO ap_payment_hist_dists

777: FND_LOG.STRING(g_level_procedure,'AP_XLA_UPGRADE_PKG.CREATE_PAYMENT_DIST_LINKS',
778: 'Insert into ap_payment_hist_dists');
779: END IF;
780:
781: INSERT INTO ap_payment_hist_dists
782: (PAYMENT_HIST_DIST_ID,
783: ACCOUNTING_EVENT_ID,
784: PAY_DIST_LOOKUP_CODE,
785: INVOICE_DISTRIBUTION_ID,

Line 800: SELECT AP_Payment_Hist_Dists_S.Nextval,

796: LAST_UPDATE_DATE,
797: LAST_UPDATED_BY,
798: LAST_UPDATE_LOGIN,
799: PA_ADDITION_FLAG)
800: SELECT AP_Payment_Hist_Dists_S.Nextval,
801: Accounting_Event_ID,
802: Pay_Dist_Lookup_Code,
803: Invoice_Distribution_ID,
804: Decode(Rank_Num, Dist_Count, Entered_Amount + Delta_Entered, Entered_Amount) Amount,

Line 996: use_nl_with_index (aphd, ap_payment_hist_dists_n1)

992: use_nl_with_index (aae, ap_accounting_events_n1)
993: use_nl_with_index (aeh, xla_ae_headers_n2)
994: use_nl_with_index (ael, xla_ae_lines_u1)
995: use_nl_with_index (aph, ap_payment_history_n2)
996: use_nl_with_index (aphd, ap_payment_hist_dists_n1)
997: use_nl_with_index (aid, ap_invoice_distributions_u2) */
998: 200 Application_ID,
999: AEH.Event_ID Accounting_Event_ID,
1000: AEH.AE_Header_ID AE_Header_ID,

Line 1073: AP_Payment_Hist_Dists APHD,

1069: AP_Accounting_Events_All AAE,
1070: AP_Payment_History_All APH,
1071: XLA_AE_Headers AEH,
1072: XLA_AE_Lines AEL,
1073: AP_Payment_Hist_Dists APHD,
1074: AP_Invoice_Distributions_All AID
1075: WHERE AC.Check_ID BETWEEN p_start_id AND p_end_id
1076: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1077: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID