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.PJM_INTEGRATION_PROJ_MFG dependencies on PA_PROJECTS_ALL

Line 32: from pa_projects_all ppa

28: select ppa.start_date
29: ,ppa.completion_date
30: into d_proj_start_date
31: ,d_proj_end_date
32: from pa_projects_all ppa
33: where ppa.project_id =p_project_id
34: ;
35: d_task_start_date :=Null;
36: d_task_end_date :=Null;

Line 46: from pa_projects_all ppa

42: into d_proj_start_date
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

Line 184: ,pa_projects_all ppa

180: cursor cu_project_manager is
181: select fu.user_name project_manager
182: from fnd_user fu
183: ,pa_project_players ppp
184: ,pa_projects_all ppa
185: where fu.employee_id =ppp.person_id
186: and nvl(fu.end_date,sysdate) >=sysdate
187: and ppp.project_role_type = 'PROJECT MANAGER'
188: and ppp.project_id = ppa.project_id