APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_ROUTE_STEPS

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

4740: -- Real code starts here -----------------------------------------------
4741: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
4742: WHERE ROUTE_PEOPLE_ID in
4743: ( select ecrp.ROUTE_PEOPLE_ID
4744: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4745: where ecrp.STEP_ID = ecrs.step_id
4746: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4747: and els.ENTITY_ID1 = p_change_id
4748: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4755: from ENG_CHANGE_ROUTE_STEPS

4751: /*( select ROUTE_PEOPLE_ID
4752: from ENG_CHANGE_ROUTE_PEOPLE
4753: where STEP_ID in
4754: ( select STEP_ID
4755: from ENG_CHANGE_ROUTE_STEPS
4756: where ROUTE_ID in
4757: ( select CHANGE_WF_ROUTE_ID
4758: from ENG_LIFECYCLE_STATUSES
4759: where ENTITY_ID1 = p_change_id

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

4764:
4765: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4766: where ROUTE_PEOPLE_ID in
4767: ( select ecrp.ROUTE_PEOPLE_ID
4768: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4769: where ecrp.STEP_ID = ecrs.step_id
4770: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4771: and els.ENTITY_ID1 = p_change_id
4772: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4779: from ENG_CHANGE_ROUTE_STEPS

4775: /*( select ROUTE_PEOPLE_ID
4776: from ENG_CHANGE_ROUTE_PEOPLE
4777: where STEP_ID in
4778: ( select STEP_ID
4779: from ENG_CHANGE_ROUTE_STEPS
4780: where ROUTE_ID in
4781: ( select CHANGE_WF_ROUTE_ID
4782: from ENG_LIFECYCLE_STATUSES
4783: where ENTITY_ID1 = p_change_id

Line 4794: from ENG_CHANGE_ROUTE_STEPS

4790:
4791: delete from ENG_CHANGE_ROUTE_PEOPLE
4792: where STEP_ID in
4793: ( select STEP_ID
4794: from ENG_CHANGE_ROUTE_STEPS
4795: where ROUTE_ID in
4796: ( select CHANGE_WF_ROUTE_ID
4797: from ENG_LIFECYCLE_STATUSES
4798: where ENTITY_ID1 = p_change_id

Line 4804: delete from ENG_CHANGE_ROUTE_STEPS_TL

4800: )
4801: );
4802:
4803:
4804: delete from ENG_CHANGE_ROUTE_STEPS_TL
4805: where STEP_ID in
4806: ( select STEP_ID
4807: from ENG_CHANGE_ROUTE_STEPS
4808: where ROUTE_ID in

Line 4807: from ENG_CHANGE_ROUTE_STEPS

4803:
4804: delete from ENG_CHANGE_ROUTE_STEPS_TL
4805: where STEP_ID in
4806: ( select STEP_ID
4807: from ENG_CHANGE_ROUTE_STEPS
4808: where ROUTE_ID in
4809: ( select CHANGE_WF_ROUTE_ID
4810: from ENG_LIFECYCLE_STATUSES
4811: where ENTITY_ID1 = p_change_id

Line 4816: delete from ENG_CHANGE_ROUTE_STEPS

4812: and ENTITY_NAME = 'ENG_CHANGE'
4813: )
4814: );
4815:
4816: delete from ENG_CHANGE_ROUTE_STEPS
4817: where ROUTE_ID in
4818: ( select CHANGE_WF_ROUTE_ID
4819: from ENG_LIFECYCLE_STATUSES
4820: where ENTITY_ID1 = p_change_id