APPS.MSC_GET_NAME dependencies on MSC_PLANS

Line 1291: from msc_plans

1287: md.source_org_instance_id <> md.sr_instance_id));
1288:
1289: CURSOR type_of_plan(p_plan_id number) IS
1290: select plan_type
1291: from msc_plans
1292: where plan_id = p_plan_id;
1293:
1294:
1295: l_action VARCHAR2(80);

Line 1305: msc_plans mp

1301:
1302: CURSOR bkt_c(p_date date) IS
1303: select bucket_index
1304: from msc_plan_buckets mpb,
1305: msc_plans mp
1306: where mp.plan_id = arg_plan_id
1307: and mp.plan_id = mpb.plan_id
1308: and mp.organization_id = mpb.organization_id
1309: and mp.sr_instance_id = mpb.sr_instance_id

Line 2002: FROM msc_plans

1998: FUNCTION plan_name(p_plan_id number) return varchar2 IS
1999:
2000: CURSOR plan_name_cur IS
2001: SELECT compile_designator
2002: FROM msc_plans
2003: WHERE plan_id = p_plan_id;
2004: l_plan_name varchar2(30);
2005:
2006: BEGIN

Line 2354: FROM msc_plans

2350:
2351: CURSOR forward_backward_days_c2 IS
2352: SELECT curr_FORWARD_days,
2353: curr_BACKWARD_days
2354: FROM msc_plans
2355: WHERE plan_id = p_plan_id;
2356:
2357: l_forward_days number;
2358: l_backward_days number;