APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJECT_STRUCTURE_UTILS

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

1018: bv.project_id project_id
1019: , bv.budget_version_id plan_version_id
1020: , DECODE ( NVL(bv.wp_version_flag, 'N')
1021: , 'Y', bv.project_structure_version_id
1022: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1023: ) wbs_struct_version_id
1024: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
1025: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code
1026: , fpo.fin_plan_type_id plan_type_id

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

1037: , 'N' SECONDARY_RBS_FLAG
1038: , DECODE( NVL(bv.wp_version_flag, 'N')
1039: , 'Y'
1040: , DECODE(bv.project_structure_version_id
1041: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- IN NUMBER
1042: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1043: , 'Y'
1044: , 'N')
1045: , 'N'

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

1038: , DECODE( NVL(bv.wp_version_flag, 'N')
1039: , 'Y'
1040: , DECODE(bv.project_structure_version_id
1041: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- IN NUMBER
1042: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1043: , 'Y'
1044: , 'N')
1045: , 'N'
1046: ) lp_flag

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

1092: )
1093: SELECT DISTINCT bv.worker_id worker_id
1094: , den.sup_project_id project_id
1095: , cbco.plan_version_id
1096: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
1097: , bv.rbs_struct_version_id
1098: , bv.plan_type_code
1099: , bv.plan_type_id
1100: , bv.time_phased_type_code