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 156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240

152: P_remit_vendor_site_id,
153: p_remit_vendor_name,
154: p_remit_vendor_site_name,
155: p_relationship_id
156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
157: WHERE a.invoice_id = l_invoice_id
158: and a.invoice_id = b.invoice_id
159: and rownum<2;
160:

Line 187: FROM ap_payment_schedules

183: P_remit_vendor_site_id,
184: p_remit_vendor_name,
185: p_remit_vendor_site_name,
186: p_relationship_id
187: FROM ap_payment_schedules
188: WHERE invoice_id = l_invoice_id
189: and payment_num = l_payment_num;
190: End if;
191:

Line 284: SELECT ap_payment_schedules_pkg.get_discount_available(

280: l_log_msg := 'Get discount available for invoice_id:' ||
281: to_char(l_invoice_id) || ' payment_num:' ||
282: to_char(l_payment_num);
283:
284: SELECT ap_payment_schedules_pkg.get_discount_available(
285: invoice_id,
286: payment_num,
287: P_check_date,
288: P_currency_code)

Line 317: SELECT SUM(ap_payment_schedules_pkg.get_discount_available(

313:
314: l_log_msg := 'Get discount available for invoice_id:' ||
315: to_char(l_invoice_id);
316:
317: SELECT SUM(ap_payment_schedules_pkg.get_discount_available(
318: invoice_id,
319: payment_num,
320: P_check_date,
321: P_currency_code))

Line 393: ap_payment_schedules_pkg.get_discount_available(

389: --
390: CURSOR payments_cursor IS
391: SELECT payment_num,
392: amount_remaining,
393: ap_payment_schedules_pkg.get_discount_available(
394: invoice_id,
395: payment_num,
396: P_check_date,
397: P_currency_code)

Line 701: ap_payment_schedules_pkg.get_discount_available(

697: AIRP.vendor_site_id,
698: AIRP.exclusive_payment_flag,
699: AIRP.accts_pay_code_combi_id,
700: AIRP.amount_remaining,
701: ap_payment_schedules_pkg.get_discount_available(
702: AIRP.invoice_id,
703: AIRP.payment_num,
704: P_check_date,
705: P_currency_code),

Line 723: ap_payment_schedules APS

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

Line 1173: FROM ap_payment_schedules, ap_interest_periods

1169: ELSE
1170: BEGIN
1171: SELECT annual_interest_rate , due_date
1172: INTO l_rate, l_due_date
1173: FROM ap_payment_schedules, ap_interest_periods
1174: WHERE payment_num = l_payment_num
1175: AND invoice_id = P_invoice_id
1176: AND trunc(due_date+1) BETWEEN trunc(start_date) AND trunc(end_date);
1177: