APPS.MSC_SCN_ACTIVITY_WF dependencies on MSC_SCENARIO_SETS

Line 25: MSC_SCENARIO_SETS MSS

21: MSA.ACT_COMMENT,
22: MS.SCENARIO_NAME, MSS.SCENARIO_SET_NAME
23: FROM MSC_SCENARIO_ACTIVITIES MSA,
24: MSC_SCENARIOS MS,
25: MSC_SCENARIO_SETS MSS
26: WHERE
27: ACTIVITY_ID= p_activity_id
28: AND MSA.SCENARIO_ID=MS.SCENARIO_ID(+)
29: AND MSA.SCENARIO_SET_ID=MSS.SCENARIO_SET_ID(+);

Line 142: MSC_SCENARIO_SETS MSS

138: MSA.ALTERNATE_OWNER, MSA.ACT_COMMENT ,
139: MS.SCENARIO_NAME , MSS.SCENARIO_SET_NAME
140: FROM MSC_SCENARIO_ACTIVITIES MSA,
141: MSC_SCENARIOS MS,
142: MSC_SCENARIO_SETS MSS
143: WHERE MSA.STATUS IN (1,2) -- 1 Not Started , 2 In Progress
144: AND MSA.FINISH_BY < TRUNC(SYSDATE)
145: AND MSA.SCENARIO_ID=MS.SCENARIO_ID(+)
146: AND MSA.SCENARIO_SET_ID=MSS.SCENARIO_SET_ID(+);