DBA Data[Home] [Help]

APPS.MSC_EXP_WF dependencies on MSC_PROJECT_TASKS

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