DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1221: From pa_proj_element_versions pelm

1217: * moved the select to cursor */
1218: IF l_struct_ver_id is NOT NULL Then
1219: UPDATE pa_res_list_map_tmp1 tmp
1220: SET tmp.TXN_WBS_ELEMENT_VERSION_ID = (Select pelm.element_version_id
1221: From pa_proj_element_versions pelm
1222: WHERE pelm.parent_structure_version_id = l_struct_ver_id
1223: AND pelm.proj_element_id = tmp.txn_task_id
1224: AND rownum = 1
1225: )