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_PO_INTEGRATION_UTILS dependencies on PA_PROJECT_PARTIES

Line 420: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr

416: and Nvl(papf.effective_end_date, Sysdate + 1)
417: and papf.person_id in
418: (
419: select f.person_id
420: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
421: ,per_all_people_f f, pa_resource_txn_attributes ptn
422: where pp.resource_id = pr.resource_id
423: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
424: and pp.project_role_id = ppr.project_role_id

Line 487: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr

483: and Nvl(papf.effective_end_date, Sysdate + 1)
484: and papf.person_id in
485: (
486: select f.person_id
487: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
488: ,per_all_people_f f, pa_resource_txn_attributes ptn
489: where pp.resource_id = pr.resource_id
490: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
491: and pp.project_role_id = ppr.project_role_id

Line 521: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr

517: and Nvl(papf.effective_end_date, Sysdate + 1)
518: and papf.person_id in
519: (
520: select f.person_id
521: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
522: ,per_all_people_f f, pa_resource_txn_attributes ptn
523: where pp.resource_id = pr.resource_id
524: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
525: and pp.project_role_id = ppr.project_role_id