APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_PROJ_STRUCTURE_TYPES

Line 1684: pa_proj_structure_types ppst

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
1688: AND ppst.structure_type_id = 1;

Line 3017: pa_proj_structure_types ppst,

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'
3021: and ppst.proj_element_id = ppevs.proj_element_id

Line 3498: pa_proj_structure_types ppst,

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'
3502: and ppst.proj_element_id = ppevs.proj_element_id