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.

[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_PROJECTS

Line 2601: FROM msc_projects proj

2597: l_custcnt varchar2(30);
2598:
2599: CURSOR PRJ_MGR_C(p_project_number in varchar2) IS
2600: SELECT proj.manager_contact
2601: FROM msc_projects proj
2602: where proj.project_number = p_project_number
2603: and proj.organization_id = l_org_id
2604: and proj.sr_instance_id = l_instance_id
2605: AND proj.plan_id = -1;

Line 2609: FROM msc_projects proj, msc_project_tasks tasks

2605: AND proj.plan_id = -1;
2606:
2607: CURSOR TSK_MGR_C(p_project_number in varchar2, p_task_number in varchar2) IS
2608: SELECT NVL(tasks.manager_contact,proj.manager_contact)
2609: FROM msc_projects proj, msc_project_tasks tasks
2610: WHERE tasks.task_number = p_task_number
2611: AND proj.project_id = tasks.project_id
2612: AND proj.project_number = p_project_number
2613: and proj.organization_id = tasks.organization_id