APPS.MSC_WS_SRP dependencies on MSC_PLAN_SCHEDULES

Line 112: decode((select count(*) from msc_plan_schedules

108: INTO l_val_launchsnapshot
109: FROM mfg_lookups
110: WHERE lookup_type = 'MSC_LAUNCH_SNAPSHOT'
111: AND lookup_code in decode(lookup_code,1,1,2,2,3,
112: decode((select count(*) from msc_plan_schedules
113: where plan_id = planId
114: and rownum = 1
115: and designator_type = 7
116: and input_type = 1),0,1,3 ) )

Line 967: INSERT INTO msc_plan_schedules

963: FcstRec IN MscIGlbRetFcstRec
964: ) RETURN VARCHAR2 AS
965: BEGIN
966: BEGIN
967: INSERT INTO msc_plan_schedules
968: (
969: plan_id, organization_id, input_schedule_id, sr_instance_id,
970: input_type, last_update_date, last_updated_by,
971: creation_date, created_by, designator_type

Line 1094: FROM msc_plan_schedules

1090: FOR I IN GlbManFcsts.first..GlbManFcsts.last
1091: LOOP
1092: BEGIN
1093: Select count(*) INTO l_Dummy
1094: FROM msc_plan_schedules
1095: WHERE
1096: plan_id = PlanId AND
1097: organization_id = -1 AND
1098: sr_instance_id = GlbManFcsts(I).InsId AND