APPS.AP_WITHHOLDING_PKG dependencies on AP_PAYMENT_SCHEDULES

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))

Line 3503: FROM ap_payment_schedules APS,

3499: SELECT APS.gross_amount
3500: , NVL(APS.inv_curr_gross_amount, APS.gross_Amount) inv_curr_gross_amount
3501: , APS.amount_remaining
3502: , AI.payment_currency_code
3503: FROM ap_payment_schedules APS,
3504: ap_invoices AI
3505: WHERE AI.invoice_id = InvId
3506: AND AI.invoice_id = APS.invoice_id
3507: AND APS.payment_num = NVL(PaymNum, APS.payment_num) /* Bug 5300858 */

Line 3546: UPDATE ap_payment_schedules

3542:
3543: IF (c_payment_sched%FOUND) THEN
3544: debug_info := 'Update the payment schedule';
3545:
3546: UPDATE ap_payment_schedules
3547: SET amount_remaining = (amount_remaining +
3548: ap_utilities_pkg.ap_round_currency(
3549: reversed_withholding *
3550: payment_cross_rate,