APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_ROUTES

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

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