DBA Data[Home] [Help]

APPS.PJM_INTEGRATION_PROJ_MFG dependencies on PA_TASKS

Line 47: ,pa_tasks pt

43: ,d_proj_end_date
44: ,d_task_start_date
45: ,d_task_end_date
46: from pa_projects_all ppa
47: ,pa_tasks pt
48: where ppa.project_id =p_project_id
49: and pt.project_id =ppa.project_id
50: and pt.task_id =p_task_id
51: ;

Line 210: ,pa_tasks pt

206:
207: cursor cu_task_manager is
208: select fu.user_name task_manager
209: from fnd_user fu
210: ,pa_tasks pt
211: where fu.employee_id =pt.task_manager_person_id
212: and nvl(fu.end_date,sysdate) >=sysdate
213: and pt.task_id = pn_task_id
214: order by fu.user_name