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 10489: pa_role_controls controls,

10485: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2,p_project_id IN number)
10486: IS
10487: select 'x'
10488: from pa_project_role_types_v roles,
10489: pa_role_controls controls,
10490: pa_projects_all proj
10491: where proj.project_id=p_project_id
10492: and proj.ROLE_LIST_ID is null
10493: and roles.project_role_id=controls.project_role_id

Line 10500: pa_role_controls controls,

10496: and trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
10497: union all
10498: select 'x'
10499: from pa_project_role_types_v roles,
10500: pa_role_controls controls,
10501: pa_projects_all proj,
10502: pa_role_list_members prlm
10503: where proj.project_id=p_project_id
10504: and proj.ROLE_LIST_ID =prlm.role_list_id