APPS.AP_WITHHOLDING_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 1051: FROM ap_payment_schedules_all

1047: ) IS
1048: SELECT gross_amount
1049: , amount_remaining
1050: , NVL(inv_curr_gross_amount, gross_Amount) inv_curr_gross_amount
1051: FROM ap_payment_schedules_all
1052: WHERE (invoice_id = InvId)
1053: AND (payment_num = decode(Createdists
1054: ,'APPROVAL',payment_num, 'BOTH',
1055: decode(P_Calling_Module,'CONFIRM',PaymNum,'QUICKCHECK',PaymNum,payment_num)

Line 1083: FROM ap_payment_schedules_all

1079: subtracting_cumulator NUMBER := 0;
1080: CURSOR c_how_many_payments (InvId IN NUMBER)
1081: IS
1082: SELECT count(*) payments
1083: FROM ap_payment_schedules_all
1084: WHERE invoice_id = InvId;
1085:
1086: num_payments NUMBER;
1087: BEGIN

Line 1189: UPDATE ap_payment_schedules_all

1185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
1187: END IF;
1188:
1189: UPDATE ap_payment_schedules_all
1190: SET amount_remaining = amount_remaining -
1191: pay_curr_amount_to_subtract,
1192: -- iyas: Following code IS in DLD but was not found originally in file:
1193: discount_amount_available = discount_amount_available -

Line 1226: UPDATE ap_payment_schedules_all

1222:
1223: -- The withholding_total should be converted to payment
1224: -- currency before substracting it FROM the amount remaining.
1225:
1226: UPDATE ap_payment_schedules_all
1227: SET amount_remaining = (amount_remaining -
1228: ap_utilities_pkg.ap_round_currency(
1229: withholding_total * rec_invoice.payment_cross_rate,
1230: rec_invoice.payment_currency_code))