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

Line 83: pa_role_controls controls,

79: CURSOR l_project_role_types_csr(p_role_type IN VARCHAR2,p_project_id IN number)
80: IS
81: SELECT 'x'
82: FROM pa_project_role_types_v roles,
83: pa_role_controls controls,
84: pa_projects_all proj
85: WHERE proj.project_id = p_project_id
86: AND proj.ROLE_LIST_ID is null
87: AND roles.project_role_id = controls.project_role_id

Line 94: pa_role_controls controls,

90: AND trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
91: UNION ALL
92: SELECT 'x'
93: FROM pa_project_role_types_v roles,
94: pa_role_controls controls,
95: pa_projects_all proj,
96: pa_role_list_members prlm
97: WHERE proj.project_id = p_project_id
98: AND proj.ROLE_LIST_ID = prlm.role_list_id