APPS.AP_CANCEL_PKG dependencies on AP_HOLD_CODES

Line 576: AP_HOLD_CODES AHC

572:
573: CURSOR Tax_Holds_Cur IS
574: SELECT AH.hold_lookup_code
575: FROM AP_HOLDS AH,
576: AP_HOLD_CODES AHC
577: WHERE AH.invoice_id = P_invoice_id
578: AND AH.hold_lookup_code = AHC.hold_lookup_code
579: AND AH.release_lookup_code IS NULL
580: AND AH.hold_lookup_code IN ('TAX AMOUNT RANGE','TAX VARIANCE');

Line 991: ,ap_hold_codes AHC

987:
988: SELECT count(*)
989: INTO l_chk_encum
990: FROM ap_holds AH
991: ,ap_hold_codes AHC
992: WHERE AH.invoice_id = P_invoice_id
993: AND AH.hold_lookup_code = AHC.hold_lookup_code
994: AND AH.release_lookup_code IS NULL
995: AND AHC.postable_flag = 'N'

Line 1060: ,ap_hold_codes AHC

1056: BEGIN
1057: SELECT count(*)
1058: INTO l_holds_count
1059: FROM ap_holds AH
1060: ,ap_hold_codes AHC
1061: WHERE AH.invoice_id = P_invoice_id
1062: AND AH.hold_lookup_code = AHC.hold_lookup_code
1063: AND AH.release_lookup_code IS NULL
1064: AND AHC.postable_flag = 'N';

Line 1086: ,ap_hold_codes AHC

1082:
1083: SELECT count(*)
1084: INTO l_tax_holds_count
1085: FROM ap_holds AH
1086: ,ap_hold_codes AHC
1087: WHERE AH.invoice_id = P_invoice_id
1088: AND AH.hold_lookup_code = AHC.hold_lookup_code
1089: AND AH.release_lookup_code IS NULL
1090: AND AH.hold_lookup_code IN ('TAX AMOUNT RANGE','TAX VARIANCE');

Line 1158: FROM ap_hold_codes

1154:
1155: UPDATE ap_holds
1156: SET release_lookup_code = 'APPROVED'
1157: ,release_reason = ( SELECT description
1158: FROM ap_hold_codes
1159: WHERE hold_lookup_code = 'APPROVED')
1160: ,last_update_date = SYSDATE
1161: ,last_updated_by = P_last_updated_by
1162: ,last_update_login = P_last_update_login