APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_CHECKS

Line 693: from ap_checks ac

689:
690: -- added to reverse the certificate.
691: select ac.payment_id
692: into l_payment_id
693: from ap_checks ac
694: where ac.check_id = l_check_id;
695:
696:
697:

Line 1230: from ap_checks

1226: -- Withholdings are not calculated for payment type = Refund.
1227: --------------------------------------------------------------
1228: Select payment_type_flag
1229: into l_payment_type
1230: from ap_checks
1231: where check_id = P_Check_id;
1232:
1233: -- Debug Information
1234: IF (DEBUG_Var = 'Y') THEN

Line 4534: FROM ap_checks apch

4530: IS
4531: SELECT apch.amount amount,
4532: apch.base_amount base_amount,
4533: apch.currency_code currency_code -- Bug 2886571
4534: FROM ap_checks apch
4535: WHERE apch.check_id = P_Check_Id
4536: FOR UPDATE OF apch.amount,
4537: apch.base_amount;
4538:

Line 4705: -- Calling the AP Table Handler to update ap_checks.

4701: CLOSE c_invoice_payment;
4702:
4703: -------------------------------------------------------------------
4704: -- Updates the payment amount for the check
4705: -- Calling the AP Table Handler to update ap_checks.
4706: -- Bug 1827398
4707: -------------------------------------------------------------------
4708: IF (l_total_wh_amount <> 0 OR l_total_wh_base_amount <> 0) THEN
4709: OPEN c_checks (P_Check_Id);

Line 5268: FROM ap_checks apchk

5264: apchk.vendor_site_code
5265: INTO l_payment_amount,
5266: l_vendor_name,
5267: l_vendor_site_code
5268: FROM ap_checks apchk
5269: WHERE apchk.check_id = P_Check_Id;
5270:
5271: --------------------------------------------
5272: -- Obtains payment amount for Payment Batch

Line 5669: FROM ap_checks apch

5665: CURSOR c_checks (P_Check_Id Number)
5666: IS
5667: SELECT apch.amount amount,
5668: apch.base_amount base_amount
5669: FROM ap_checks apch
5670: WHERE apch.check_id = P_Check_Id
5671: FOR UPDATE OF apch.amount,
5672: apch.base_amount;
5673:

Line 5870: -- Calling the AP Table Handler to update ap_checks.

5866: CLOSE c_invoice_payment;
5867:
5868: -------------------------------------------------------------------
5869: -- Updates the payment amount for the check
5870: -- Calling the AP Table Handler to update ap_checks.
5871: -------------------------------------------------------------------
5872: IF (l_total_wh_amount <> 0 OR l_total_wh_base_amount <> 0) THEN
5873: OPEN c_checks (P_Check_Id);
5874: FETCH c_checks INTO l_amount, l_base_amount;