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

Line 160: FROM pa_projects

156: , pm_product_code
157: , carrying_out_organization_id
158: , project_status_code
159: , template_flag -- Bug 6875403
160: FROM pa_projects
161: WHERE project_id = l_project_id;
162: --
163: CURSOR l_organization_csr ( l_carrying_out_organization_id NUMBER )
164: IS

Line 245: WHERE object_type = 'PA_PROJECTS'

241: IS
242: SELECT change_comment FROM (
243: SELECT change_comment
244: FROM pa_obj_status_changes
245: WHERE object_type = 'PA_PROJECTS'
246: AND object_id = l_project_id
247: AND new_project_status_code =
248: (SELECT project_status_code
249: FROM pa_projects_all

Line 249: FROM pa_projects_all

245: WHERE object_type = 'PA_PROJECTS'
246: AND object_id = l_project_id
247: AND new_project_status_code =
248: (SELECT project_status_code
249: FROM pa_projects_all
250: WHERE project_id = l_project_id)
251: ORDER BY obj_status_change_id DESC
252: )
253: WHERE rownum = 1;