DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_PLANS

Line 958: msc_plans mp

954: PROCEDURE update_table IS
955: CURSOR bucket IS
956: SELECT mpb.bkt_start_date, mpb.bkt_end_date
957: FROM msc_plan_buckets mpb,
958: msc_plans mp
959: where mp.plan_id = g_plan_id
960: and mp.plan_id = mpb.plan_id
961: and mp.organization_id = mpb.organization_id
962: and mp.sr_instance_id = mpb.sr_instance_id

Line 1439: msc_plans mp

1435: p_res_id NUMBER) IS
1436: CURSOR bucket IS
1437: SELECT mpb.bkt_start_date, mpb.bkt_end_date
1438: FROM msc_plan_buckets mpb,
1439: msc_plans mp
1440: WHERE mp.plan_id = v_plan_id
1441: and mp.plan_id = mpb.plan_id
1442: and mp.sr_instance_id = mpb.sr_instance_id
1443: and mp.organization_id = mpb.organization_id

Line 1635: msc_plans mp

1631:
1632: CURSOR bucket IS
1633: SELECT mpb.bkt_start_date, mpb.bkt_end_date
1634: FROM msc_plan_buckets mpb,
1635: msc_plans mp
1636: where mp.plan_id = p_plan_id
1637: and mp.plan_id = mpb.plan_id
1638: and mp.organization_id = mpb.organization_id
1639: and mp.sr_instance_id = mpb.sr_instance_id