APPS.AP_APPROVAL_PKG dependencies on AP_HOLD_CODES

Line 2177: FROM ap_holds H, ap_hold_codes C

2173: SELECT 'Y'
2174: INTO l_unpostable_holds_exist
2175: FROM dual
2176: WHERE EXISTS (SELECT 1
2177: FROM ap_holds H, ap_hold_codes C
2178: WHERE H.invoice_id = l_invoice_id
2179: AND H.hold_lookup_code = C.hold_lookup_code
2180: AND ((H.release_lookup_code IS NULL)
2181: AND ((C.postable_flag = 'N') OR (C.postable_flag = 'X')) AND C.user_releaseable_flag = 'N'));

Line 6024: ap_hold_codes AHC

6020: WHERE AID1.invoice_id = AI.invoice_id
6021: AND AID1.awt_group_id IS NOT NULL)
6022: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
6023: FROM ap_holds AH,
6024: ap_hold_codes AHC
6025: WHERE AH.invoice_id = AI.invoice_id
6026: AND AH.release_lookup_code IS NULL
6027: AND AH.hold_lookup_code <> 'AWT ERROR'
6028: AND AH.hold_lookup_code = AHC.hold_lookup_code

Line 6114: ap_hold_codes AHC

6110: FROM ap_invoices_all AI
6111: WHERE AI.invoice_id = p_invoice_id
6112: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
6113: FROM ap_holds AH,
6114: ap_hold_codes AHC
6115: WHERE AH.invoice_id = AI.invoice_id
6116: AND AH.release_lookup_code IS NULL
6117: AND AH.hold_lookup_code <> 'AWT ERROR'
6118: AND AH.hold_lookup_code = AHC.hold_lookup_code

Line 6325: FROM ap_holds H, ap_hold_codes C

6321: WHERE match_status_flag = 'T'
6322: AND D.invoice_id = p_invoice_id
6323: AND ((NOT EXISTS
6324: (SELECT invoice_id
6325: FROM ap_holds H, ap_hold_codes C
6326: WHERE H.invoice_id = D.invoice_id
6327: AND H.hold_lookup_code = C.hold_lookup_code
6328: AND ((H.release_lookup_code IS NULL) AND
6329: ((C.postable_flag = 'N') OR

Line 6345: FROM ap_holds H, ap_hold_codes C

6341: WHERE match_status_flag = 'T'
6342: AND D.invoice_id = p_invoice_id
6343: AND ((NOT EXISTS
6344: (SELECT invoice_id
6345: FROM ap_holds H, ap_hold_codes C
6346: WHERE H.invoice_id = D.invoice_id
6347: AND H.hold_lookup_code = C.hold_lookup_code
6348: AND ((H.release_lookup_code IS NULL) AND
6349: ((C.postable_flag = 'N') OR

Line 7149: FROM ap_hold_codes

7145: SELECT user_releaseable_flag,
7146: initiate_workflow_flag
7147: INTO l_user_releaseable_flag,
7148: l_initiate_workflow_flag
7149: FROM ap_hold_codes
7150: WHERE hold_lookup_code = p_hold_lookup_code;
7151:
7152: --
7153: -- If the hold is a user releaseable hold then we will start the

Line 9178: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;

9174: p_transaction_num IN NUMBER) RETURN BOOLEAN -- Bug 8234569
9175:
9176: IS
9177:
9178: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
9179: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type INDEX BY BINARY_INTEGER;
9180: TYPE invoiceNUMTab IS TABLE OF ap_invoices.invoice_num%Type INDEX BY BINARY_INTEGER;
9181: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
9182: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;

Line 9847: FROM AP_HOLD_CODES

9843: ''CANT CLOSE PO'', ''CANT TRY PO CLOSE'', ''LINE VARIANCE'',
9844: ''CANT FUNDS CHECK'',''Expired Registration'',''Amount Funded'',''Quantity Funded'',
9845: ''GTAS Mandatory Fields'',''GTAS Data Validation'')) OR /* Bug#13464635 */
9846: (H.HOLD_LOOKUP_CODE IN (SELECT HOLD_LOOKUP_CODE
9847: FROM AP_HOLD_CODES
9848: WHERE POSTABLE_FLAG = ''N''
9849: AND USER_RELEASEABLE_FLAG = ''N''))) /* Bug 14579876 */
9850: AND H.RELEASE_LOOKUP_CODE IS NULL
9851: AND EXISTS

Line 12594: ap_hold_codes AHC

12590: l_debug_info := 'Before getting the count of unreleased fund holds';
12591: SELECT count(*)
12592: INTO l_chk_encum
12593: FROM ap_holds AH,
12594: ap_hold_codes AHC
12595: WHERE AH.invoice_id = P_invoice_id
12596: AND AH.hold_lookup_code = AHC.hold_lookup_code
12597: AND AH.release_lookup_code IS NULL
12598: AND AHC.postable_flag = 'N'