DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_PROJECTS

Line 2607: FROM msc_projects proj

2603: l_custcnt varchar2(30);
2604:
2605: CURSOR PRJ_MGR_C(p_project_number in varchar2) IS
2606: SELECT proj.manager_contact
2607: FROM msc_projects proj
2608: where proj.project_number = p_project_number
2609: and proj.organization_id = l_org_id
2610: and proj.sr_instance_id = l_instance_id
2611: AND proj.plan_id = -1;

Line 2615: FROM msc_projects proj, msc_project_tasks tasks

2611: AND proj.plan_id = -1;
2612:
2613: CURSOR TSK_MGR_C(p_project_number in varchar2, p_task_number in varchar2) IS
2614: SELECT NVL(tasks.manager_contact,proj.manager_contact)
2615: FROM msc_projects proj, msc_project_tasks tasks
2616: WHERE tasks.task_number = p_task_number
2617: AND proj.project_id = tasks.project_id
2618: AND proj.project_number = p_project_number
2619: and proj.organization_id = tasks.organization_id