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_STRUCTURE_TYPES

Line 122: pa_structure_types pst,

118:
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'

Line 135: pa_structure_types pst,

131: CURSOR c_get_element_information(c_project_id NUMBER, c_proj_element_id NUMBER, c_object_type VARCHAR2, c_structure_type VARCHAR2) IS
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

Line 2081: pa_structure_types pst,

2077: -- Bug 3606627 : Added curosrs c_get_structure_information, c_get_task_weight_method
2078: CURSOR c_get_structure_information(c_project_id NUMBER, c_structure_type VARCHAR2) IS
2079: select ppevs.proj_element_id, ppevs.element_version_id
2080: from pa_proj_structure_types ppst,
2081: pa_structure_types pst,
2082: pa_proj_elem_ver_structure ppevs
2083: where ppevs.project_id = c_project_id
2084: and ppevs.proj_element_id = ppst.proj_element_id
2085: and ppevs.status_code = 'STRUCTURE_PUBLISHED'