DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_PROJECT_TASKS

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