DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1572: FROM pa_proj_elem_ver_structure ppevs,

1568:
1569: BEGIN
1570: SELECT element_version_id
1571: INTO l_lpb_struct_ver_id
1572: FROM pa_proj_elem_ver_structure ppevs,
1573: pa_proj_structure_types ppst
1574: WHERE ppevs.project_id = p_project_id
1575: AND latest_eff_published_flag = 'Y'
1576: AND ppst.proj_element_id = ppevs.proj_element_id

Line 2389: FROM pa_proj_elem_ver_structure ppevs,

2385: UPDATE pji_plan_extr_tmp TMP
2386: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
2387: (
2388: SELECT element_version_id,bv.budget_version_id
2389: FROM pa_proj_elem_ver_structure ppevs,
2390: pa_proj_structure_types ppst,
2391: pa_budget_versions bv
2392: WHERE 1=1
2393: and latest_eff_published_flag = 'Y'