eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_PLANS

Line 805: msc_plans mp

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
809: and mp.sr_instance_id = mpb.sr_instance_id

Line 1161: msc_plans mp

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
1165: and mp.organization_id = mpb.organization_id

Line 1357: msc_plans mp

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
1361: and mp.sr_instance_id = mpb.sr_instance_id