DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_PLAN_BUCKETS

Line 804: FROM msc_plan_buckets mpb,

800: -----------------------------------------------------------------------------
801: PROCEDURE update_table IS
802: CURSOR bucket IS
803: SELECT mpb.bkt_start_date, mpb.bkt_end_date
804: FROM msc_plan_buckets mpb,
805: msc_plans mp
806: where mp.plan_id = g_plan_id
807: and mp.plan_id = mpb.plan_id
808: and mp.organization_id = mpb.organization_id

Line 1160: FROM msc_plan_buckets mpb,

1156: p_dept_id NUMBER,
1157: p_res_id NUMBER) IS
1158: CURSOR bucket IS
1159: SELECT mpb.bkt_start_date, mpb.bkt_end_date
1160: FROM msc_plan_buckets mpb,
1161: msc_plans mp
1162: WHERE mp.plan_id = v_plan_id
1163: and mp.plan_id = mpb.plan_id
1164: and mp.sr_instance_id = mpb.sr_instance_id

Line 1356: FROM msc_plan_buckets mpb,

1352: v_shift_date date;
1353:
1354: CURSOR bucket IS
1355: SELECT mpb.bkt_start_date, mpb.bkt_end_date
1356: FROM msc_plan_buckets mpb,
1357: msc_plans mp
1358: where mp.plan_id = p_plan_id
1359: and mp.plan_id = mpb.plan_id
1360: and mp.organization_id = mpb.organization_id