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

Line 658: FROM msc_planners

654:
655:
656: CURSOR C1 IS
657: SELECT employee_id
658: FROM msc_planners
659: WHERE planner_code = p_planner_code
660: AND organization_id = p_org_id
661: AND sr_instance_id = p_inst_id
662: AND current_employee_flag = 1;

Line 666: FROM msc_planners mp,

662: AND current_employee_flag = 1;
663:
664: CURSOR C2 IS
665: SELECT employee_id
666: FROM msc_planners mp,
667: msc_system_items msi
668: WHERE mp.planner_code = msi.planner_code
669: AND mp.organization_id = msi.organization_id
670: AND mp.sr_instance_id = msi.sr_instance_id

Line 771: FROM msc_planners mp

767: l_plan_type number :=1 ; -- temp set as ASCP plan
768:
769: CURSOR empl_C IS
770: SELECT mp.employee_id
771: FROM msc_planners mp
772: WHERE mp.planner_code = p_planner_code
773: AND mp.organization_id = p_org_id
774: AND mp.sr_instance_id = p_inst_id
775: AND mp.current_employee_flag = 1;