APPS.AP_WITHHOLDING_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 528: FROM ap_payment_schedules_all

524: ) IS
525: SELECT gross_amount
526: , amount_remaining
527: , NVL(inv_curr_gross_amount, gross_Amount) inv_curr_gross_amount
528: FROM ap_payment_schedules_all
529: WHERE (invoice_id = InvId)
530: AND (payment_num = decode(Createdists
531: ,'APPROVAL',payment_num, 'BOTH',payment_num
532: ,PaymNum

Line 555: FROM ap_payment_schedules_all

551: subtracting_cumulator NUMBER := 0;
552: CURSOR c_how_many_payments (InvId IN NUMBER)
553: IS
554: SELECT count(*) payments
555: FROM ap_payment_schedules_all
556: WHERE invoice_id = InvId;
557:
558: num_payments NUMBER;
559: BEGIN

Line 620: UPDATE ap_payment_schedules_all

616:
617: -- Update current payment schedule:
618: debug_info := 'Update current payment schedule';
619:
620: UPDATE ap_payment_schedules_all
621: SET amount_remaining = amount_remaining -
622: pay_curr_amount_to_subtract,
623: -- iyas: Following code IS in DLD but was not found originally in file:
624: discount_amount_available = discount_amount_available -

Line 650: UPDATE ap_payment_schedules_all

646:
647: -- The withholding_total should be converted to payment
648: -- currency before substracting it FROM the amount remaining.
649:
650: UPDATE ap_payment_schedules_all
651: SET amount_remaining = (amount_remaining -
652: ap_utilities_pkg.ap_round_currency(
653: withholding_total * rec_invoice.payment_cross_rate,
654: rec_invoice.payment_currency_code))