APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_HOLDS

Line 1937: FROM ap_holds H

1933: AND L.rcv_transaction_id = RTXN.transaction_id(+)
1934: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
1935: AND (I.payment_status_flag IN ('N', 'P')
1936: OR EXISTS (SELECT 'Holds have to be released'
1937: FROM ap_holds H
1938: WHERE H.invoice_id = I.invoice_id
1939: AND H.release_lookup_code is null
1940: AND H.hold_lookup_code in
1941: ('QTY ORD', 'QTY REC',

Line 3379: FROM ap_holds AH

3375: SELECT 'Y'
3376: INTO l_holds_exist
3377: FROM sys.dual
3378: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3379: FROM ap_holds AH
3380: WHERE AH.invoice_id = p_invoice_id
3381: AND AH.hold_lookup_code NOT IN (p_hold_code, p_hold_code2)
3382: AND AH.release_lookup_code IS NULL);
3383:

Line 3431: FROM ap_holds AH

3427: SELECT 'Y'
3428: INTO l_holds_exist
3429: FROM sys.dual
3430: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3431: FROM ap_holds AH
3432: WHERE AH.invoice_id = p_invoice_id
3433: AND AH.hold_lookup_code IN (p_hold_code, p_hold_code2)
3434: AND AH.release_lookup_code IS NULL);
3435:

Line 3651: ap_holds AH,

3647: CURSOR Final_Match_Release_Cur IS
3648: SELECT PD.line_location_id,
3649: 'CANT CLOSE PO'
3650: FROM ap_invoice_distributions AID,
3651: ap_holds AH,
3652: po_distributions_ap_v PD,
3653: po_line_locations PLL --Bug 3489536
3654: WHERE AH.invoice_id = p_invoice_id
3655: AND AH.hold_lookup_code = 'CANT CLOSE PO'

Line 3667: ap_holds AH,

3663: UNION
3664: SELECT PD.line_location_id,
3665: 'CANT TRY PO CLOSE'
3666: FROM ap_invoice_distributions AID,
3667: ap_holds AH,
3668: po_distributions_ap_v PD,
3669: po_line_locations PLL --Bug 3489536
3670: WHERE AH.invoice_id = p_invoice_id
3671: AND AH.hold_lookup_code = 'CANT TRY PO CLOSE'