APPS.AP_APXCRRCR_XMLP_PKG dependencies on AP_HOLDS

Line 245: AP_HOLDS HC

241: SELECT
242: COUNT(HC.HOLD_LOOKUP_CODE)
243: INTO L_HOLD_COUNT
244: FROM
245: AP_HOLDS HC
246: WHERE HC.INVOICE_ID = C_INVOICE_ID
247: AND HC.RELEASE_LOOKUP_CODE IS NULL;
248: RETURN (L_HOLD_COUNT);
249: END;

Line 279: AP_HOLDS H

275: WHERE ( ( NOT EXISTS (
276: SELECT
277: 'Unreleased holds exist'
278: FROM
279: AP_HOLDS H
280: WHERE H.INVOICE_ID = C_INVOICE_ID
281: AND H.RELEASE_LOOKUP_CODE is null ) )
282: AND ( EXISTS (
283: SELECT