APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 1045: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

1041: bv.project_id project_id
1042: , bv.budget_version_id plan_version_id
1043: , DECODE ( NVL(bv.wp_version_flag, 'N')
1044: , 'Y', bv.project_structure_version_id
1045: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1046: ) wbs_struct_version_id
1047: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
1048: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code
1049: , fpo.fin_plan_type_id plan_type_id

Line 1064: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- IN NUMBER

1060: , 'N' SECONDARY_RBS_FLAG
1061: , DECODE( NVL(bv.wp_version_flag, 'N')
1062: , 'Y'
1063: , DECODE(bv.project_structure_version_id
1064: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- IN NUMBER
1065: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1066: , 'Y'
1067: , 'N')
1068: , 'N'

Line 1065: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

1061: , DECODE( NVL(bv.wp_version_flag, 'N')
1062: , 'Y'
1063: , DECODE(bv.project_structure_version_id
1064: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- IN NUMBER
1065: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1066: , 'Y'
1067: , 'N')
1068: , 'N'
1069: ) lp_flag

Line 1119: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id

1115: )
1116: SELECT DISTINCT bv.worker_id worker_id
1117: , den.sup_project_id project_id
1118: , cbco.plan_version_id
1119: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
1120: , bv.rbs_struct_version_id
1121: , bv.plan_type_code
1122: , bv.plan_type_id
1123: , bv.time_phased_type_code