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

Line 123: pa_proj_elem_ver_structure ppevs

119: CURSOR c_get_structure_information(c_project_id NUMBER, c_structure_type VARCHAR2) IS
120: select ppevs.proj_element_id, ppevs.element_version_id
121: from pa_proj_structure_types ppst,
122: pa_structure_types pst,
123: pa_proj_elem_ver_structure ppevs
124: where ppevs.project_id = c_project_id
125: and ppevs.proj_element_id = ppst.proj_element_id
126: and ppevs.status_code = 'STRUCTURE_PUBLISHED'
127: and ppevs.LATEST_EFF_PUBLISHED_FLAG = 'Y'

Line 136: pa_proj_elem_ver_structure ppevs

132: select elev.element_version_id, elev.parent_structure_version_id
133: from pa_proj_element_versions elev,
134: pa_proj_structure_types ppst,
135: pa_structure_types pst,
136: pa_proj_elem_ver_structure ppevs
137: where elev.project_id = c_project_id
138: and elev.object_type = c_object_type
139: and elev.proj_element_id = c_proj_element_id
140: and elev.parent_structure_version_id = ppevs.element_version_id

Line 2078: pa_proj_elem_ver_structure ppevs

2074: CURSOR c_get_structure_information(c_project_id NUMBER, c_structure_type VARCHAR2) IS
2075: select ppevs.proj_element_id, ppevs.element_version_id
2076: from pa_proj_structure_types ppst,
2077: pa_structure_types pst,
2078: pa_proj_elem_ver_structure ppevs
2079: where ppevs.project_id = c_project_id
2080: and ppevs.proj_element_id = ppst.proj_element_id
2081: and ppevs.status_code = 'STRUCTURE_PUBLISHED'
2082: and ppevs.LATEST_EFF_PUBLISHED_FLAG = 'Y'