DBA Data[Home] [Help]

APPS.MSC_WS_SCENARIO_MANAGEMENT dependencies on MSC_PROC_INST_ACT_PARAMS

Line 669: FROM msc_proc_inst_act_params

665: ProcessScope IN VARCHAR2
666: ) AS
667: CURSOR getParameter_c (idProcess NUMBER, seqRun NUMBER, nameActivity VARCHAR2) IS
668: SELECT param_name, param_value
669: FROM msc_proc_inst_act_params
670: WHERE process_id = idProcess AND
671: run_sequence = seqRun AND
672: activity_id =
673: ( SELECT activity_id FROM msc_planning_proc_activities

Line 696: FROM msc_proc_inst_act_params

692: CLOSE getParameter_c;
693:
694: IF ParameterValues.count = 0 THEN
695: SELECT count(*) INTO l_Dummy
696: FROM msc_proc_inst_act_params
697: WHERE process_id = ProcessId AND
698: run_sequence = RunSequence AND
699: activity_id =
700: ( SELECT activity_id FROM msc_planning_proc_activities