APPS.JE_JEFILPIP_XMLP_PKG dependencies on AP_HOLDS

Line 275: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih1.invoice_id from ap_holds aih1' || ' where aih1.invoice_id = id.invoice_id'

271: IF NVL(ENCUMBRANCE_FLAG
272: ,'N') = 'N' THEN
273: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' AND nvl(aid1.match_status_flag,''N'') not in (''A'', ''T'')) ';
274: END IF;
275: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih1.invoice_id from ap_holds aih1' || ' where aih1.invoice_id = id.invoice_id'
276: || ' and aih1.release_lookup_code is null))' || 'and exists' || '(select null from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id)';
277: END IF;
278: IF P_MATCH_STATUS_FLAG = 'N' THEN
279: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id';

Line 287: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih2.invoice_id from ap_holds aih2' || ' where aih2.invoice_id = id.invoice_id' || ' and aih2.release_lookup_code is null))';

283: IF NVL(ENCUMBRANCE_FLAG
284: ,'N') = 'N' THEN
285: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' AND nvl(aid2.match_status_flag,''N'') not in (''A'', ''T'')) ';
286: END IF;
287: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih2.invoice_id from ap_holds aih2' || ' where aih2.invoice_id = id.invoice_id' || ' and aih2.release_lookup_code is null))';
288: END IF;
289: IF P_INV_POSTED_FLAG IS NOT NULL THEN
290: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || 'and nvl(ach1.gl_transfer_status_code,''N'')=''' || P_INV_POSTED_FLAG || ''' ';
291: END IF;

Line 722: AP_HOLDS AIH

718: SELECT
719: count(*)
720: INTO A_COUNT
721: FROM
722: AP_HOLDS AIH
723: WHERE AIH.INVOICE_ID = P_INVOICE_ID
724: AND AIH.RELEASE_LOOKUP_CODE is null;
725: IF (A_COUNT <> 0) THEN
726: A_FLAG := C_NO;