APPS.PA_INTEGRATION_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 457: from pa_budget_versions a , pa_proj_fp_options b

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
459: and a.budget_status_code = 'W'
460: and a.current_working_flag = 'Y'
461: and a.fin_plan_type_id = b.fin_plan_type_id

Line 482: FROM pa_proj_fp_options

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
484: and project_id = p_project_id
485: and fin_plan_option_level_code = 'PLAN_TYPE';
486: EXCEPTION