DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_ROUTE_PEOPLE

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 4752: from ENG_CHANGE_ROUTE_PEOPLE

4748: and els.ENTITY_NAME = 'ENG_CHANGE'
4749: );
4750: --Fixed for bug 4958931
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

Line 4765: delete from ENG_CHANGE_ROUTE_PEOPLE_tl

4761: )
4762: )
4763: );*/
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

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 4776: from ENG_CHANGE_ROUTE_PEOPLE

4772: and els.ENTITY_NAME = 'ENG_CHANGE'
4773: );
4774: --Fixed for bug 4958931
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

Line 4791: delete from ENG_CHANGE_ROUTE_PEOPLE

4787: );*/
4788:
4789:
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