eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PAYMENT_PUBLIC_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 696: FROM ap_payment_schedules_all PS,

692: 0) * DECODE(SIGN(ps.gross_amount),-1,-1,1))
693: * (PS.AMOUNT_REMAINING / DECODE(PS.GROSS_AMOUNT,
694: 0, 1,
695: PS.GROSS_AMOUNT))))
696: FROM ap_payment_schedules_all PS,
697: ap_invoices_all ai,
698: ap_supplier_sites_all asi
699: WHERE ai.invoice_id = ps.invoice_id
700: AND ai.vendor_id = asi.vendor_id

Line 705: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;

701: AND ai.vendor_site_id = asi.vendor_site_id
702: AND ai.invoice_id = c_invoice_id
703: AND ps.payment_num = c_payment_num;
704:
705: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
706: Netting_Exception EXCEPTION;
707: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
708: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Payment_Schedule';
709:

Line 759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;

755: P_Payment_Num IN NUMBER,
756: P_Date IN DATE,
757: P_Netted_Amt IN NUMBER)
758: RETURN NUMBER IS
759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;
760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;
762: l_inv_curr ap_invoices_all.invoice_currency_code%type;
763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;

756: P_Date IN DATE,
757: P_Netted_Amt IN NUMBER)
758: RETURN NUMBER IS
759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;
760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;
762: l_inv_curr ap_invoices_all.invoice_currency_code%type;
763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
764: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Netted_Amt';

Line 761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;

757: P_Netted_Amt IN NUMBER)
758: RETURN NUMBER IS
759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;
760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;
762: l_inv_curr ap_invoices_all.invoice_currency_code%type;
763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
764: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Netted_Amt';
765: Netting_Exception EXCEPTION;

Line 780: FROM ap_payment_schedules_all

776:
777: --Get Amount Remaining to be paid for the given Invoice and Payment Number
778: SELECT amount_remaining
779: INTO l_amount_remaining
780: FROM ap_payment_schedules_all
781: WHERE invoice_id = P_Invoice_Id
782: AND payment_num = P_Payment_Num;
783:
784: --Get the Discount Amount available on the payment