APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES_READY_TO_PAY_V

Line 85: FROM ap_invoices_ready_to_pay_v

81: to_char(l_invoice_id);
82:
83: SELECT count(*) + l_num_payments
84: INTO l_num_payments
85: FROM ap_invoices_ready_to_pay_v
86: WHERE invoice_id = l_invoice_id;
87:
88: ELSE
89: -- Parse and count P_payment_num_list

Line 290: FROM ap_invoices_ready_to_pay_v

286: payment_num,
287: P_check_date,
288: P_currency_code)
289: INTO l_discount_available
290: FROM ap_invoices_ready_to_pay_v
291: WHERE invoice_id = l_invoice_id
292: AND payment_num = l_payment_num;
293:
294: EXIT WHEN (l_discount_available > 0 OR

Line 323: FROM ap_invoices_ready_to_pay_v

319: payment_num,
320: P_check_date,
321: P_currency_code))
322: INTO l_discount_available
323: FROM ap_invoices_ready_to_pay_v
324: WHERE invoice_id = l_invoice_id;
325:
326: EXIT WHEN (l_discount_available > 0 OR
327: l_next > LENGTH(P_invoice_id_list));

Line 398: FROM ap_invoices_ready_to_pay_v

394: invoice_id,
395: payment_num,
396: P_check_date,
397: P_currency_code)
398: FROM ap_invoices_ready_to_pay_v
399: WHERE invoice_id = P_invoice_id
400: AND payment_num = nvl(P_payment_num, payment_num);
401:
402: BEGIN

Line 722: FROM ap_invoices_ready_to_pay_v AIRP,

718: APS.attribute13,
719: APS.attribute14,
720: APS.attribute15,
721: APS.attribute_category
722: FROM ap_invoices_ready_to_pay_v AIRP,
723: ap_payment_schedules APS
724: WHERE AIRP.invoice_id = P_invoice_id
725: AND AIRP.payment_num = nvl(P_payment_num, AIRP.payment_num)
726: AND APS.invoice_id = AIRP.invoice_id