DBA Data[Home] [Help]

APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 142: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

138: , bv.project_id project_id
139: , bv.budget_version_id plan_version_id
140: , DECODE ( NVL(bv.wp_version_flag, 'N')
141: , 'Y', bv.project_structure_version_id
142: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
143: ) wbs_struct_version_id
144: , fpo.rbs_version_id rbs_struct_version_id
145: -- , to_char(fpo.fin_plan_type_id) plan_type_code
146: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 165: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

161: , 'N' SECONDARY_RBS_FLAG
162: , DECODE( NVL(bv.wp_version_flag, 'N')
163: , 'Y'
164: , DECODE(bv.project_structure_version_id
165: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
166: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
167: , 'Y'
168: , 'N')
169: , 'N'

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

162: , DECODE( NVL(bv.wp_version_flag, 'N')
163: , 'Y'
164: , DECODE(bv.project_structure_version_id
165: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
166: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
167: , 'Y'
168: , 'N')
169: , 'N'
170: ) lp_flag