DBA Data[Home] [Help]

APPS.PA_INTEGRATION_UTILS dependencies on PA_FIN_PLAN_UTILS

Line 454: select PA_FIN_PLAN_UTILS.Get_Fin_Plan_Level_Code(a.budget_version_id),

450:
451: IF (p_fin_plan_type_id IS NOT NULL) THEN
452:
453: BEGIN
454: select PA_FIN_PLAN_UTILS.Get_Fin_Plan_Level_Code(a.budget_version_id),
455: a.resource_list_id
456: into l_level_code,l_resource_list_id
457: from pa_budget_versions a , pa_proj_fp_options b
458: where a.project_id = p_project_id

Line 479: SELECT PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(proj_fp_options_id,fin_plan_preference_code),

475: END ;
476:
477: IF ( l_ver_not_found = 'Y' ) THEN
478: BEGIN
479: SELECT PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(proj_fp_options_id,fin_plan_preference_code),
480: DECODE(all_resource_list_id,NULL, cost_resource_list_id,all_resource_list_id)
481: INTO l_level_code,l_resource_list_id
482: FROM pa_proj_fp_options
483: WHERE fin_plan_type_id = p_fin_plan_type_id