DBA Data[Home] [Help]

APPS.GMO_VALIDATE_BATCH_GRP dependencies on QA_RESULTS_V

Line 278: from qa_results_v

274: close c_get_materials;
275:
276: -- Chenck for NCM
277: select count(*) into l_ncm_count
278: from qa_results_v
279: where PROCESS_BATCH_ID = p_entity_key
280: and NONCONFORMANCE_STATUS <> 'CLOSED';
281: IF l_ncm_count > 0 THEN
282: raise NCM_NOT_CLOSED;

Line 342: from qa_results_v

338: close c_get_step_materials;
339:
340: -- Chenck for NCM
341: select count(*) into l_ncm_count
342: from qa_results_v
343: where PROCESS_BATCHSTEP_ID = p_entity_key
344: and NONCONFORMANCE_STATUS <> 'CLOSED';
345: IF l_ncm_count > 0 THEN
346: raise NCM_NOT_CLOSED;