APPS.AP_PAY_IN_FULL_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 24: P_payment_method OUT NOCOPY AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE, --VARCHAR2,

20: PROCEDURE AP_Lock_Invoices(
21: P_invoice_id_list IN VARCHAR2,
22: P_payment_num_list IN VARCHAR2,
23: P_currency_code OUT NOCOPY VARCHAR2,
24: P_payment_method OUT NOCOPY AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE, --VARCHAR2,
25: P_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
26: P_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
28: P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,

Line 161: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240

157: P_remit_vendor_site_id,
158: p_remit_vendor_name,
159: p_remit_vendor_site_name,
160: p_relationship_id
161: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
162: WHERE a.invoice_id = l_invoice_id
163: and a.invoice_id = b.invoice_id
164: and rownum<2;
165:

Line 192: FROM ap_payment_schedules

188: P_remit_vendor_site_id,
189: p_remit_vendor_name,
190: p_remit_vendor_site_name,
191: p_relationship_id
192: FROM ap_payment_schedules
193: WHERE invoice_id = l_invoice_id
194: and payment_num = l_payment_num;
195: End if;
196:

Line 332: SELECT ap_payment_schedules_pkg.get_discount_available(

328: l_log_msg := 'Get discount available for invoice_id:' ||
329: to_char(l_invoice_id) || ' payment_num:' ||
330: to_char(l_payment_num);
331:
332: SELECT ap_payment_schedules_pkg.get_discount_available(
333: invoice_id,
334: payment_num,
335: P_check_date,
336: P_currency_code)

Line 365: SELECT SUM(ap_payment_schedules_pkg.get_discount_available(

361:
362: l_log_msg := 'Get discount available for invoice_id:' ||
363: to_char(l_invoice_id);
364:
365: SELECT SUM(ap_payment_schedules_pkg.get_discount_available(
366: invoice_id,
367: payment_num,
368: P_check_date,
369: P_currency_code))

Line 441: ap_payment_schedules_pkg.get_discount_available(

437: --
438: CURSOR payments_cursor IS
439: SELECT payment_num,
440: amount_remaining,
441: ap_payment_schedules_pkg.get_discount_available(
442: invoice_id,
443: payment_num,
444: P_check_date,
445: P_currency_code)

Line 752: ap_payment_schedules_pkg.get_discount_available(

748: AIRP.vendor_site_id,
749: AIRP.exclusive_payment_flag,
750: AIRP.accts_pay_code_combi_id,
751: AIRP.amount_remaining,
752: ap_payment_schedules_pkg.get_discount_available(
753: AIRP.invoice_id,
754: AIRP.payment_num,
755: P_check_date,
756: P_currency_code),

Line 774: ap_payment_schedules APS

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
778: AND APS.payment_num = AIRP.payment_num;

Line 1352: FROM ap_payment_schedules, ap_interest_periods

1348: ELSE
1349: BEGIN
1350: SELECT annual_interest_rate , due_date
1351: INTO l_rate, l_due_date
1352: FROM ap_payment_schedules, ap_interest_periods
1353: WHERE payment_num = l_payment_num
1354: AND invoice_id = P_invoice_id
1355: AND trunc(due_date+1) BETWEEN trunc(start_date) AND trunc(end_date);
1356: