APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_HOLDS

Line 2165: FROM ap_holds H

2161: AND L.rcv_transaction_id = RTXN.transaction_id(+)
2162: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
2163: AND (I.payment_status_flag IN ('N', 'P')
2164: OR EXISTS (SELECT 'Holds have to be released'
2165: FROM ap_holds H
2166: WHERE H.invoice_id = I.invoice_id
2167: AND H.release_lookup_code is null
2168: AND H.hold_lookup_code in
2169: ('QTY ORD', 'QTY REC',

Line 3822: FROM ap_holds AH

3818: SELECT 'Y'
3819: INTO l_holds_exist
3820: FROM sys.dual
3821: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3822: FROM ap_holds AH
3823: WHERE AH.invoice_id = p_invoice_id
3824: AND AH.hold_lookup_code NOT IN (p_hold_code, p_hold_code2)
3825: AND AH.release_lookup_code IS NULL);
3826:

Line 3874: FROM ap_holds AH

3870: SELECT 'Y'
3871: INTO l_holds_exist
3872: FROM sys.dual
3873: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3874: FROM ap_holds AH
3875: WHERE AH.invoice_id = p_invoice_id
3876: AND AH.hold_lookup_code IN (p_hold_code, p_hold_code2)
3877: AND AH.release_lookup_code IS NULL);
3878:

Line 4094: ap_holds AH,

4090: CURSOR Final_Match_Release_Cur IS
4091: SELECT PD.line_location_id,
4092: 'CANT CLOSE PO'
4093: FROM ap_invoice_distributions AID,
4094: ap_holds AH,
4095: po_distributions_ap_v PD,
4096: po_line_locations PLL --Bug 3489536
4097: WHERE AH.invoice_id = p_invoice_id
4098: AND AH.hold_lookup_code = 'CANT CLOSE PO'

Line 4110: ap_holds AH,

4106: UNION
4107: SELECT PD.line_location_id,
4108: 'CANT TRY PO CLOSE'
4109: FROM ap_invoice_distributions AID,
4110: ap_holds AH,
4111: po_distributions_ap_v PD,
4112: po_line_locations PLL --Bug 3489536
4113: WHERE AH.invoice_id = p_invoice_id
4114: AND AH.hold_lookup_code = 'CANT TRY PO CLOSE'