DBA Data[Home] [Help]

APPS.MSC_SCN_ACTIVITY_WF dependencies on MSC_SCENARIO_ACTIVITIES

Line 23: FROM MSC_SCENARIO_ACTIVITIES MSA,

19: CURSOR C_ACTIVITYINFO (p_activity_id in number) IS
20: SELECT MSA.ACTIVITY_NAME, MSA.FINISH_BY, MSA.PRIORITY, MSA.STATUS, MSA.OWNER, MSA.ALTERNATE_OWNER,
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

Line 140: FROM MSC_SCENARIO_ACTIVITIES MSA,

136: MSA.FINISH_BY , MSA.PRIORITY ,
137: MSA.STATUS , MSA.OWNER ,
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)