APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 1141: FROM ap_payment_hist_dists APHD,

1137: AND APIP.accounting_date <= P_acctg_date
1138: AND APIP.set_of_books_id = P_ledger_id
1139: AND APIP.invoice_payment_id IN (
1140: SELECT APHD.invoice_payment_id
1141: FROM ap_payment_hist_dists APHD,
1142: ap_invoice_distributions_all APID
1143: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
1144: AND APIP.ACCOUNTING_EVENT_ID=APHD.ACCOUNTING_EVENT_ID --bug5461146
1145: AND APHD.invoice_distribution_id = APID.invoice_distribution_id

Line 1416: ap_payment_hist_dists APHD,

1412: APIP.invoice_payment_id
1413: FROM ap_invoice_distributions_all APID,
1414: ap_invoice_lines_all APIL,
1415: ap_invoice_payments_all APIP,
1416: ap_payment_hist_dists APHD,
1417: ap_invoices_all API,
1418: ap_batches_all APB,
1419: po_distributions_all POD,
1420: po_headers_all POH,

Line 2010: FROM ap_payment_hist_dists APHD,

2006: AND APIP.posted_flag = 'Y'
2007: AND APIP.set_of_books_id = l_ledger_id
2008: AND APIP.invoice_payment_id IN (
2009: SELECT APHD.invoice_payment_id
2010: FROM ap_payment_hist_dists APHD,
2011: ap_invoice_distributions_all APID,
2012: fa_mass_additions_gt FMAG
2013: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2014: AND APHD.invoice_distribution_id =

Line 2038: FROM ap_payment_hist_dists APHD,

2034: AND APIP.posted_flag = 'Y'
2035: AND APIP.set_of_books_id = l_ledger_id
2036: AND APIP.invoice_payment_id IN (
2037: SELECT APHD.invoice_payment_id
2038: FROM ap_payment_hist_dists APHD,
2039: ap_invoice_distributions_all APID,
2040: fa_mass_additions_gt FMAG
2041: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2042: AND APHD.invoice_distribution_id =