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_PROJECT_PUB dependencies on PA_ROLE_CONTROLS

Line 10751: pa_role_controls controls,

10747: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2,p_project_id IN number)
10748: IS
10749: select 'x'
10750: from pa_project_role_types_v roles,
10751: pa_role_controls controls,
10752: pa_projects_all proj
10753: where proj.project_id=p_project_id
10754: and proj.ROLE_LIST_ID is null
10755: and roles.project_role_id=controls.project_role_id

Line 10762: pa_role_controls controls,

10758: and trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
10759: union all
10760: select 'x'
10761: from pa_project_role_types_v roles,
10762: pa_role_controls controls,
10763: pa_projects_all proj,
10764: pa_role_list_members prlm
10765: where proj.project_id=p_project_id
10766: and proj.ROLE_LIST_ID =prlm.role_list_id