APPS.AP_WEB_PAYMENTS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 13: gl_date ap_invoice_payments.accounting_date%TYPE,

9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: method ap_checks.payment_method_lookup_code%TYPE,
16: method_trans ap_lookup_codes.displayed_field%TYPE);
17:

Line 14: type ap_invoice_payments.invoice_payment_type%TYPE,

10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: method ap_checks.payment_method_lookup_code%TYPE,
16: method_trans ap_lookup_codes.displayed_field%TYPE);
17:
18: -----------------------------------------------------------------------

Line 34: FROM ap_invoice_payments aip,

30: aip.accounting_date,
31: aip.invoice_payment_type,
32: ac.payment_method_lookup_code,
33: alc2.displayed_field
34: FROM ap_invoice_payments aip,
35: ap_checks ac,
36: ap_invoices ai,
37: ap_lookup_codes alc2
38: WHERE aip.invoice_id = l_invoice_id

Line 54: FROM ap_invoice_payments aip,

50: aip.accounting_date,
51: aip.invoice_payment_type,
52: ac.payment_method_lookup_code,
53: alc2.displayed_field
54: FROM ap_invoice_payments aip,
55: ap_checks ac,
56: ap_invoices ai,
57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,

Line 167: FROM AP_INVOICE_PAYMENTS AIP, AP_INVOICES AI

163:
164: BEGIN
165: SELECT SUM(AIP.AMOUNT)
166: INTO l_total_payment_made
167: FROM AP_INVOICE_PAYMENTS AIP, AP_INVOICES AI
168: WHERE AIP.INVOICE_ID = AI.INVOICE_ID
169: AND AI.INVOICE_ID = l_invoice_id;
170:
171: RETURN(l_total_payment_made);

Line 194: FROM ap_invoice_payments aip,

190: SELECT check_id
191: INTO l_check_id
192: FROM
193: ( SELECT ac.check_id check_id
194: FROM ap_invoice_payments aip,
195: ap_checks ac
196: WHERE aip.check_id = ac.check_id
197: AND aip.invoice_id = l_invoice_id
198: UNION ALL

Line 200: FROM ap_invoice_payments aip,

196: WHERE aip.check_id = ac.check_id
197: AND aip.invoice_id = l_invoice_id
198: UNION ALL
199: SELECT ac.check_id check_id
200: FROM ap_invoice_payments aip,
201: ap_checks ac,
202: ap_invoice_lines ail1,
203: ap_invoice_lines ail2,
204: ap_invoice_distributions aid1,

Line 245: FROM ap_invoice_payments aip,

241: SELECT MAX(check_date)
242: INTO l_last_payment_date
243: FROM
244: ( SELECT ac.check_date check_date
245: FROM ap_invoice_payments aip,
246: ap_checks ac
247: WHERE aip.check_id = ac.check_id
248: AND aip.invoice_id = l_invoice_id
249: UNION ALL

Line 251: FROM ap_invoice_payments aip,

247: WHERE aip.check_id = ac.check_id
248: AND aip.invoice_id = l_invoice_id
249: UNION ALL
250: SELECT ac.check_date check_date
251: FROM ap_invoice_payments aip,
252: ap_checks ac,
253: ap_invoice_lines ail1,
254: ap_invoice_lines ail2,
255: ap_invoice_distributions aid1,