DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1683: FROM pa_proj_elem_ver_structure ppevs,

1679:
1680: BEGIN
1681: SELECT element_version_id
1682: INTO l_lpb_struct_ver_id
1683: FROM pa_proj_elem_ver_structure ppevs,
1684: pa_proj_structure_types ppst
1685: WHERE ppevs.project_id = p_project_id
1686: AND latest_eff_published_flag = 'Y'
1687: AND ppst.proj_element_id = ppevs.proj_element_id

Line 3016: FROM pa_proj_elem_ver_structure ppevs,

3012: UPDATE pji_plan_extr_tmp TMP
3013: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
3014: (
3015: SELECT element_version_id,bv.budget_version_id
3016: FROM pa_proj_elem_ver_structure ppevs,
3017: pa_proj_structure_types ppst,
3018: pa_budget_versions bv
3019: WHERE 1=1
3020: and latest_eff_published_flag = 'Y'

Line 3497: FROM pa_proj_elem_ver_structure ppevs,

3493: UPDATE pji_plan_extr_tmp TMP
3494: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
3495: (
3496: SELECT element_version_id,bv.budget_version_id
3497: FROM pa_proj_elem_ver_structure ppevs,
3498: pa_proj_structure_types ppst,
3499: pa_budget_versions bv
3500: WHERE 1=1
3501: and latest_eff_published_flag = 'Y'