APPS.AP_CANCEL_PKG dependencies on AP_HOLD_CODES

Line 589: AP_HOLD_CODES AHC

585:
586: CURSOR Tax_Holds_Cur IS
587: SELECT AH.hold_lookup_code
588: FROM AP_HOLDS AH,
589: AP_HOLD_CODES AHC
590: WHERE AH.invoice_id = P_invoice_id
591: AND AH.hold_lookup_code = AHC.hold_lookup_code
592: AND AH.release_lookup_code IS NULL
593: AND AH.hold_lookup_code IN ('TAX AMOUNT RANGE','TAX VARIANCE');

Line 1174: ,ap_hold_codes AHC

1170: BEGIN
1171: SELECT count(*)
1172: INTO l_holds_count
1173: FROM ap_holds AH
1174: ,ap_hold_codes AHC
1175: WHERE AH.invoice_id = P_invoice_id
1176: AND AH.hold_lookup_code = AHC.hold_lookup_code
1177: AND AH.release_lookup_code IS NULL
1178: AND AHC.postable_flag = 'N';

Line 1200: ,ap_hold_codes AHC

1196:
1197: SELECT count(*)
1198: INTO l_tax_holds_count
1199: FROM ap_holds AH
1200: ,ap_hold_codes AHC
1201: WHERE AH.invoice_id = P_invoice_id
1202: AND AH.hold_lookup_code = AHC.hold_lookup_code
1203: AND AH.release_lookup_code IS NULL
1204: AND AH.hold_lookup_code IN ('TAX AMOUNT RANGE','TAX VARIANCE');

Line 1318: FROM ap_hold_codes

1314:
1315: UPDATE ap_holds
1316: SET release_lookup_code = 'APPROVED'
1317: ,release_reason = ( SELECT description
1318: FROM ap_hold_codes
1319: WHERE hold_lookup_code = 'APPROVED')
1320: ,last_update_date = SYSDATE
1321: ,last_updated_by = P_last_updated_by
1322: ,last_update_login = P_last_update_login