APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_CHECKS

Line 705: from ap_checks ac

701:
702: -- added to reverse the certificate.
703: select ac.payment_id
704: into l_payment_id
705: from ap_checks ac
706: where ac.check_id = l_check_id;
707:
708:
709:

Line 1287: from ap_checks

1283: -- Withholdings are not calculated for payment type = Refund.
1284: --------------------------------------------------------------
1285: Select payment_type_flag
1286: into l_payment_type
1287: from ap_checks
1288: where check_id = P_Check_id;
1289:
1290: -- Debug Information
1291: IF (DEBUG_Var = 'Y') THEN

Line 4770: FROM ap_checks apch

4766: IS
4767: SELECT apch.amount amount,
4768: apch.base_amount base_amount,
4769: apch.currency_code currency_code -- Bug 2886571
4770: FROM ap_checks apch
4771: WHERE apch.check_id = P_Check_Id
4772: FOR UPDATE OF apch.amount,
4773: apch.base_amount;
4774:

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

4938: CLOSE c_invoice_payment;
4939:
4940: -------------------------------------------------------------------
4941: -- Updates the payment amount for the check
4942: -- Calling the AP Table Handler to update ap_checks.
4943: -- Bug 1827398
4944: -------------------------------------------------------------------
4945: IF (l_total_wh_amount <> 0 OR l_total_wh_base_amount <> 0) THEN
4946: OPEN c_checks (P_Check_Id);

Line 5559: FROM ap_checks apchk

5555: apchk.vendor_site_code
5556: INTO l_payment_amount,
5557: l_vendor_name,
5558: l_vendor_site_code
5559: FROM ap_checks apchk
5560: WHERE apchk.check_id = P_Check_Id;
5561:
5562: --------------------------------------------
5563: -- Obtains payment amount for Payment Batch

Line 5999: FROM ap_checks apch

5995: CURSOR c_checks (P_Check_Id Number)
5996: IS
5997: SELECT apch.amount amount,
5998: apch.base_amount base_amount
5999: FROM ap_checks apch
6000: WHERE apch.check_id = P_Check_Id
6001: FOR UPDATE OF apch.amount,
6002: apch.base_amount;
6003:

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

6197: CLOSE c_invoice_payment;
6198:
6199: -------------------------------------------------------------------
6200: -- Updates the payment amount for the check
6201: -- Calling the AP Table Handler to update ap_checks.
6202: -------------------------------------------------------------------
6203: IF (l_total_wh_amount <> 0 OR l_total_wh_base_amount <> 0) THEN
6204: OPEN c_checks (P_Check_Id);
6205: FETCH c_checks INTO l_amount, l_base_amount;