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_PLAN_RELEASE dependencies on MSC_PLANNERS

Line 768: FROM msc_planners

764:
765:
766: CURSOR C1 IS
767: SELECT employee_id
768: FROM msc_planners
769: WHERE planner_code = p_planner_code
770: AND organization_id = p_org_id
771: AND sr_instance_id = p_inst_id
772: AND current_employee_flag = 1;

Line 776: FROM msc_planners mp,

772: AND current_employee_flag = 1;
773:
774: CURSOR C2 IS
775: SELECT employee_id
776: FROM msc_planners mp,
777: msc_system_items msi
778: WHERE mp.planner_code = msi.planner_code
779: AND mp.organization_id = msi.organization_id
780: AND mp.sr_instance_id = msi.sr_instance_id

Line 881: FROM msc_planners mp

877: l_plan_type number :=1 ; -- temp set as ASCP plan
878:
879: CURSOR empl_C IS
880: SELECT mp.employee_id
881: FROM msc_planners mp
882: WHERE mp.planner_code = p_planner_code
883: AND mp.organization_id = p_org_id
884: AND mp.sr_instance_id = p_inst_id
885: AND mp.current_employee_flag = 1;