APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 186: select /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N3) */

182: log.ATTRIBUTE20
183: from
184: PA_PJI_PROJ_EVENTS_LOG log,
185: (
186: select /*+ ordered index(ver PA_PROJ_ELEMENT_VERSIONS_N3) */
187: distinct
188: ver.PRG_GROUP
189: from
190: PJI_PJP_PROJ_BATCH_MAP map,

Line 191: PA_PROJ_ELEMENT_VERSIONS ver

187: distinct
188: ver.PRG_GROUP
189: from
190: PJI_PJP_PROJ_BATCH_MAP map,
191: PA_PROJ_ELEMENT_VERSIONS ver
192: where
193: map.WORKER_ID = p_worker_id and
194: map.PROJECT_ID = ver.PROJECT_ID and
195: ver.PRG_GROUP is not null

Line 2821: PA_PROJ_ELEMENT_VERSIONS sub_ver,

2817: 'NEW_CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
2818: from
2819: PJI_XBS_DENORM_DELTA prg,
2820: PJI_PJP_RBS_HEADER sup_rbs_hdr,
2821: PA_PROJ_ELEMENT_VERSIONS sub_ver,
2822: PA_RBS_VERSIONS_B hdr
2823: where
2824: prg.STRUCT_TYPE = 'PRG' and
2825: prg.SUP_ID <> prg.SUB_ID and

Line 4265: PA_PROJ_ELEMENT_VERSIONS ver,

4261: PA_RBS_TXN_ACCUM_MAP rbs,
4262: PJI_PJP_PROJ_BATCH_MAP map,
4263: PJI_ORG_EXTR_INFO info,
4264: PJI_PJP_WBS_HEADER wbs_hdr,
4265: PA_PROJ_ELEMENT_VERSIONS ver,
4266: (
4267: select 1 INVERT_ID from dual
4268: where l_g1_currency_code is not null union all
4269: select 2 INVERT_ID from dual

Line 4961: PA_PROJ_ELEMENT_VERSIONS ver,

4957: )
4958: ) src,
4959: PJI_PJP_PROJ_BATCH_MAP map,
4960: PJI_PJP_WBS_HEADER wbs_hdr,
4961: PA_PROJ_ELEMENT_VERSIONS ver,
4962: (
4963: select 1 INVERT_ID from dual
4964: where l_g1_currency_code is not null union all
4965: select 2 INVERT_ID from dual

Line 16361: from PA_PROJ_ELEMENT_VERSIONS ver

16357: select distinct struct_version_id bulk collect
16358: into l_wbs_version_id_tbl
16359: from (
16360: select ver.element_version_id struct_version_id
16361: from PA_PROJ_ELEMENT_VERSIONS ver
16362: where ver.OBJECT_TYPE = 'PA_STRUCTURES' and
16363: ver.PRG_GROUP in
16364: (select
16365: decode(invert.INVERT_ID,

Line 16408: PA_PROJ_ELEMENT_VERSIONS ver

16404: where SUP_PROJECT_ID in
16405: (select
16406: ver.PROJECT_ID
16407: from
16408: PA_PROJ_ELEMENT_VERSIONS ver
16409: where
16410: ver.OBJECT_TYPE = 'PA_STRUCTURES' and
16411: ver.PRG_GROUP in
16412: (select

Line 16506: PA_PROJ_ELEMENT_VERSIONS ver

16502: den.SUP_PROJECT_ID in
16503: (select
16504: ver.PROJECT_ID
16505: from
16506: PA_PROJ_ELEMENT_VERSIONS ver
16507: where
16508: ver.OBJECT_TYPE = 'PA_STRUCTURES' and
16509: ver.PRG_GROUP in
16510: (select

Line 17301: pa_proj_element_versions ver,

17297: SELECT nvl(ver.PRG_LEVEL,1) PRG_LEVEL,
17298: ver.PROJECT_ID
17299: FROM
17300: pji_pjp_proj_batch_map map,
17301: pa_proj_element_versions ver,
17302: pa_proj_structure_types typ,
17303: pa_proj_elem_ver_structure str
17304: WHERE
17305: typ.STRUCTURE_TYPE_ID = 1