DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 121: from pa_proj_structure_types ppst,

117: l_task_status VARCHAR2(150); --Bug 2751159
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

Line 134: pa_proj_structure_types ppst,

130:
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

Line 2076: from pa_proj_structure_types ppst,

2072:
2073: -- Bug 3606627 : Added curosrs c_get_structure_information, c_get_task_weight_method
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