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.PJI_EXTRACTION_UTIL dependencies on PA_PROJECT_STATUSES

Line 17: , pa_project_statuses sts

13: l_extr_start_date date;
14: Cursor csr_purge_projs is
15: select prj.project_id, sts.project_system_status_code
16: from pa_projects_all prj
17: , pa_project_statuses sts
18: where prj.project_status_code = sts.project_status_code
19: and sts.project_system_status_code in ('PARTIALLY_PURGED'
20: ,'PURGED'
21: ,'PENDING_PURGE')

Line 90: PA_PROJECT_STATUSES sts,

86: 'CONTRACT', 'B',
87: 'INDIRECT', 'I')
88: from
89: PA_PROJECTS_ALL prj,
90: PA_PROJECT_STATUSES sts,
91: PA_PROJECT_TYPES_ALL pt,
92: (
93: select
94: PROJECT_STATUS_CODE