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_PWP_NOTIFICATION dependencies on PA_PROJECTS

Line 73: FROM pa_projects p, pa_project_statuses ps

69: ,completion_date End_Date
70: ,project_type Project_Type
71: ,carrying_out_organization_id Organization_Id
72: ,ps.project_status_name Project_Status
73: FROM pa_projects p, pa_project_statuses ps
74: WHERE segment1 = p_project_num
75: and ps.project_status_code = p.project_status_code
76: and ps.status_type = 'PROJECT';
77:

Line 110: AND ppp.object_type = 'PA_PROJECTS'

106: AND ppp.project_role_id = 1
107: AND ppp.resource_type_id = 101
108: AND ppp.resource_source_id = pe.person_id
109: AND TRUNC(SYSDATE) BETWEEN pe.effective_start_date AND pe.effective_end_date
110: AND ppp.object_type = 'PA_PROJECTS'
111: AND TRUNC(SYSDATE) BETWEEN ppp.start_date_active AND NVL(ppp.end_date_active,TRUNC(SYSDATE)+1);
112:
113: END PA_PWP_NOTIFICATION;