APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES_READY_TO_PAY_V

Line 90: FROM ap_invoices_ready_to_pay_v

86: to_char(l_invoice_id);
87:
88: SELECT count(*) + l_num_payments
89: INTO l_num_payments
90: FROM ap_invoices_ready_to_pay_v
91: WHERE invoice_id = l_invoice_id;
92:
93: ELSE
94: -- Parse and count P_payment_num_list

Line 338: FROM ap_invoices_ready_to_pay_v

334: payment_num,
335: P_check_date,
336: P_currency_code)
337: INTO l_discount_available
338: FROM ap_invoices_ready_to_pay_v
339: WHERE invoice_id = l_invoice_id
340: AND payment_num = l_payment_num;
341:
342: EXIT WHEN (l_discount_available > 0 OR

Line 371: FROM ap_invoices_ready_to_pay_v

367: payment_num,
368: P_check_date,
369: P_currency_code))
370: INTO l_discount_available
371: FROM ap_invoices_ready_to_pay_v
372: WHERE invoice_id = l_invoice_id;
373:
374: EXIT WHEN (l_discount_available > 0 OR
375: l_next > LENGTH(P_invoice_id_list));

Line 446: FROM ap_invoices_ready_to_pay_v

442: invoice_id,
443: payment_num,
444: P_check_date,
445: P_currency_code)
446: FROM ap_invoices_ready_to_pay_v
447: WHERE invoice_id = P_invoice_id
448: AND payment_num = nvl(P_payment_num, payment_num);
449:
450: BEGIN

Line 773: FROM ap_invoices_ready_to_pay_v AIRP,

769: APS.attribute13,
770: APS.attribute14,
771: APS.attribute15,
772: APS.attribute_category
773: FROM ap_invoices_ready_to_pay_v AIRP,
774: ap_payment_schedules APS
775: WHERE AIRP.invoice_id = P_invoice_id
776: AND AIRP.payment_num = nvl(P_payment_num, AIRP.payment_num)
777: AND APS.invoice_id = AIRP.invoice_id