APPS.JG_JGZZSRCR_XMLP_PKG dependencies on AP_HOLDS

Line 376: ' (select aih1.invoice_id from ap_holds aih1' ||

372: ,'N') = 'N' THEN
373: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' AND nvl(aid1.match_status_flag,''N'') not in (''A'', ''T'')) ';
374: END IF;
375: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' ||
376: ' (select aih1.invoice_id from ap_holds aih1' ||
377: ' where aih1.invoice_id = id.invoice_id' ||
378: ' and aih1.release_lookup_code is null))' ||
379: 'and exists' || '(select null from ap_invoice_distributions aid2' ||
380: ' where aid2.invoice_id = id.invoice_id)';

Line 393: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih2.invoice_id from ap_holds aih2' ||

389: IF NVL(ENCUMBRANCE_FLAG
390: ,'N') = 'N' THEN
391: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' AND nvl(aid2.match_status_flag,''N'') not in (''A'', ''T'')) ';
392: END IF;
393: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih2.invoice_id from ap_holds aih2' ||
394: ' where aih2.invoice_id = id.invoice_id' || ' and aih2.release_lookup_code is null))';
395: END IF;
396: IF P_INV_POSTED_FLAG IS NOT NULL THEN
397: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || 'and nvl(ach1.gl_transfer_flag,''N'')=''' || P_INV_POSTED_FLAG || ''' ';

Line 754: AP_HOLDS AIH

750: SELECT
751: count(*)
752: INTO A_COUNT
753: FROM
754: AP_HOLDS AIH
755: WHERE AIH.INVOICE_ID = INVOICE_ID_v
756: AND AIH.RELEASE_LOOKUP_CODE is null;
757: IF (A_COUNT <> 0) THEN
758: A_FLAG := C_NO;