DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 209: ap_invoice_distributions_all aid_prepay,

205: -- bug9441420
206: CURSOR Prepay_Appl IS
207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID
213: AND aip.invoice_id = aid_prepay.invoice_id

Line 211: ap_invoice_distributions_all aid

207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID
213: AND aip.invoice_id = aid_prepay.invoice_id
214: AND aid_prepay.invoice_id = ai_prepay.invoice_id
215: AND ai_prepay.invoice_type_lookup_code = 'PREPAYMENT'

Line 624: INSERT INTO ap_invoice_distributions_all

620:
621: l_max_dist_line_num := l_max_dist_line_num + 1;
622:
623:
624: INSERT INTO ap_invoice_distributions_all
625: (INVOICE_ID,
626: DIST_CODE_COMBINATION_ID,
627: INVOICE_DISTRIBUTION_ID,
628: INVOICE_LINE_NUMBER, /* bug 5169128 */