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_DATES_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 61: FROM PA_PROJ_ELEM_VER_STRUCTURE

57:
58: CURSOR latest_published_ver_csr
59: IS
60: SELECT element_version_id
61: FROM PA_PROJ_ELEM_VER_STRUCTURE
62: WHERE project_id = p_project_id
63: AND latest_eff_published_flag = 'Y';
64:
65: CURSOR get_task_sch_dates_csr(c_structure_version_id NUMBER, c_task_id NUMBER)

Line 166: from pa_proj_elem_ver_structure

162:
163: CURSOR get_latest_struct_ver(c_structure_id NUMBER)
164: IS
165: select element_version_id
166: from pa_proj_elem_ver_structure
167: where project_id = p_project_id
168: and proj_element_id = c_structure_id
169: and status_code = 'STRUCTURE_PUBLISHED'
170: and latest_eff_published_flag = 'Y';

Line 175: from pa_proj_elem_ver_structure

171:
172: CURSOR get_work_struct_ver(c_structure_id NUMBER)
173: IS
174: SELECT element_version_id
175: from pa_proj_elem_ver_structure
176: where project_id = p_project_id
177: and proj_element_id = c_structure_id
178: and status_code <> 'STRUCTURE_PUBLISHED';
179: