APPS.AP_WEB_PAYMENTS_PKG dependencies on AP_INVOICES

Line 11: invoice_num ap_invoices.invoice_num%TYPE,

7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%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,

Line 12: invoice_id ap_invoices.invoice_id%TYPE,

8: RECORD (check_number ap_checks.check_number%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);

Line 36: ap_invoices ai,

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
39: AND aip.payment_num = l_payment_num
40: AND aip.check_id = ac.check_id

Line 56: ap_invoices ai,

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,
59: ap_invoice_lines ail2,
60: ap_invoice_distributions aid1,

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 302: FROM ap_invoice_distributions aid,ap_invoices ai

298: IF (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'Y' )THEN
299:
300: SELECT SUM(nvl(prepay_amount_remaining,amount))
301: INTO l_prepay_amt_invoiced
302: FROM ap_invoice_distributions aid,ap_invoices ai
303: WHERE aid.invoice_id = P_invoice_id
304: AND aid.line_type_lookup_code IN ('ITEM','TAX')
305: AND nvl(aid.reversal_flag,'N') <> 'Y'
306: AND ai.invoice_id = P_invoice_id

Line 314: FROM ap_invoice_distributions aid,ap_invoices ai

310:
311: ELSE
312: SELECT SUM(nvl(prepay_amount_remaining,amount))
313: INTO l_prepay_amt_invoiced
314: FROM ap_invoice_distributions aid,ap_invoices ai
315: WHERE aid.invoice_id = P_invoice_id
316: AND aid.line_type_lookup_code IN ('ITEM','TAX')
317: AND nvl(aid.reversal_flag,'N') <> 'Y'
318: AND ai.invoice_id = P_invoice_id

Line 388: FROM ap_invoice_distributions aid,ap_invoices ai

384:
385: BEGIN
386: SELECT SUM(NVL(prepay_amount_remaining,amount))
387: INTO l_prepay_amt_invoiced
388: FROM ap_invoice_distributions aid,ap_invoices ai
389: WHERE aid.invoice_id = P_invoice_id
390: AND aid.line_type_lookup_code IN ('ITEM','TAX')
391: AND NVL(aid.reversal_flag,'N') <> 'Y'
392: AND ai.invoice_id = P_invoice_id