DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_ROUND_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 575: AP_Prepay_History_All APH

571: --
572: SELECT SUM(APAD.Base_Amount)
573: INTO l_sum_prepay_base_amt
574: FROM AP_Prepay_App_Dists APAD,
575: AP_Prepay_History_All APH
576: WHERE ((APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
577: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
578: 'PREPAY APPL NONREC TAX'))
579: OR (APAD.AWT_Related_ID = l_inv_dist_rec.invoice_distribution_id

Line 668: from ap_prepay_history_all

664: ELSE
665: IF p_prepay_hist_rec.prepay_history_id IS NOT NULL THEN
666: select accounting_event_id
667: into l_pad_rec.accounting_event_id
668: from ap_prepay_history_all
669: where prepay_history_id = p_prepay_hist_rec.prepay_history_id;
670: END IF;
671: END IF;
672:

Line 2979: ap_prepay_history_all APH

2975:
2976: SELECT NVL(ASP.Invrate_for_prepay_tax, 'N')
2977: INTO l_invrate_for_prepay
2978: FROM ap_system_parameters_all ASP,
2979: ap_prepay_history_all APH
2980: WHERE ASP.Org_id = APH.Org_id
2981: AND APH.Prepay_history_id = P_Prepay_Hist_Rec.Prepay_History_ID;
2982:
2983: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN