APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_ROUTE_STEPS

Line 4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4311: -- Real code starts here -----------------------------------------------
4312: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
4313: WHERE ROUTE_PEOPLE_ID in
4314: ( select ecrp.ROUTE_PEOPLE_ID
4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4316: where ecrp.STEP_ID = ecrs.step_id
4317: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4318: and els.ENTITY_ID1 = p_change_id
4319: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4326: from ENG_CHANGE_ROUTE_STEPS

4322: /*( select ROUTE_PEOPLE_ID
4323: from ENG_CHANGE_ROUTE_PEOPLE
4324: where STEP_ID in
4325: ( select STEP_ID
4326: from ENG_CHANGE_ROUTE_STEPS
4327: where ROUTE_ID in
4328: ( select CHANGE_WF_ROUTE_ID
4329: from ENG_LIFECYCLE_STATUSES
4330: where ENTITY_ID1 = p_change_id

Line 4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4335:
4336: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4337: where ROUTE_PEOPLE_ID in
4338: ( select ecrp.ROUTE_PEOPLE_ID
4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4340: where ecrp.STEP_ID = ecrs.step_id
4341: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4342: and els.ENTITY_ID1 = p_change_id
4343: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4350: from ENG_CHANGE_ROUTE_STEPS

4346: /*( select ROUTE_PEOPLE_ID
4347: from ENG_CHANGE_ROUTE_PEOPLE
4348: where STEP_ID in
4349: ( select STEP_ID
4350: from ENG_CHANGE_ROUTE_STEPS
4351: where ROUTE_ID in
4352: ( select CHANGE_WF_ROUTE_ID
4353: from ENG_LIFECYCLE_STATUSES
4354: where ENTITY_ID1 = p_change_id

Line 4365: from ENG_CHANGE_ROUTE_STEPS

4361:
4362: delete from ENG_CHANGE_ROUTE_PEOPLE
4363: where STEP_ID in
4364: ( select STEP_ID
4365: from ENG_CHANGE_ROUTE_STEPS
4366: where ROUTE_ID in
4367: ( select CHANGE_WF_ROUTE_ID
4368: from ENG_LIFECYCLE_STATUSES
4369: where ENTITY_ID1 = p_change_id

Line 4375: delete from ENG_CHANGE_ROUTE_STEPS_TL

4371: )
4372: );
4373:
4374:
4375: delete from ENG_CHANGE_ROUTE_STEPS_TL
4376: where STEP_ID in
4377: ( select STEP_ID
4378: from ENG_CHANGE_ROUTE_STEPS
4379: where ROUTE_ID in

Line 4378: from ENG_CHANGE_ROUTE_STEPS

4374:
4375: delete from ENG_CHANGE_ROUTE_STEPS_TL
4376: where STEP_ID in
4377: ( select STEP_ID
4378: from ENG_CHANGE_ROUTE_STEPS
4379: where ROUTE_ID in
4380: ( select CHANGE_WF_ROUTE_ID
4381: from ENG_LIFECYCLE_STATUSES
4382: where ENTITY_ID1 = p_change_id

Line 4387: delete from ENG_CHANGE_ROUTE_STEPS

4383: and ENTITY_NAME = 'ENG_CHANGE'
4384: )
4385: );
4386:
4387: delete from ENG_CHANGE_ROUTE_STEPS
4388: where ROUTE_ID in
4389: ( select CHANGE_WF_ROUTE_ID
4390: from ENG_LIFECYCLE_STATUSES
4391: where ENTITY_ID1 = p_change_id