APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_ROUTES

Line 195: FROM ENG_CHANGE_ROUTES WHERE OBJECT_ID1 = p_change_id AND status_code = 'IN_PROGRESS';

191: -- First check whether any workflow is running for this NIR.
192: -- If running, then abort the workflow.
193: SELECT WF_ITEM_TYPE, WF_ITEM_KEY, WF_PROCESS_NAME
194: INTO l_wf_item_type, l_wf_item_key, l_wf_process_name
195: FROM ENG_CHANGE_ROUTES WHERE OBJECT_ID1 = p_change_id AND status_code = 'IN_PROGRESS';
196:
197: IF SQL%FOUND THEN
198:
199: Eng_Workflow_Util.AbortWorkflow