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.

APPS.PA_UTILS4 dependencies on PA_TASKS

Line 35: FROM pa_tasks task

31: WHERE igc.project_id IS NOT NULL
32: AND igc.project_id = pp.project_id
33: AND pp.project_id = p_project_id
34: AND igc.task_id IN ( SELECT task.task_id
35: FROM pa_tasks task
36: WHERE task.project_id = pp.project_id
37: CONNECT BY PRIOR task.TASK_ID = task.PARENT_TASK_ID
38: START WITH task.TASK_ID = p_task_id
39: )

Line 242: ,pa_tasks t

238: ,t.work_type_id)
239: ) work_type_id
240: FROM pa_projects_all pp
241: ,pa_project_assignments ppasgn
242: ,pa_tasks t
243: WHERE pp.project_id = p_project_id
244: AND t.task_id = p_task_id
245: AND t.project_id = pp.project_id
246: AND ppasgn.assignment_id = p_assignment_id

Line 256: ,pa_tasks t

252:
253: CURSOR cur_Task_worktype IS
254: select Decode(t.work_type_id,NULL,pp.work_type_id,t.work_type_id) work_type_id
255: FROM pa_projects_all pp
256: ,pa_tasks t
257: WHERE pp.project_id = p_project_id
258: AND t.task_id = p_task_id
259: AND t.project_id = pp.project_id ;
260: