APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_FIN_PLAN_TYPES_VL

Line 753: FROM pa_fin_plan_types_vl fin,

749: IF p_calling_mode='IMPLEMENT' THEN
750:
751: SELECT name
752: INTO l_targ_pt_name
753: FROM pa_fin_plan_types_vl fin,
754: pa_budget_versions pbv
755: WHERE fin.fin_plan_type_id = pbv.fin_plan_type_id
756: AND pbv.budget_version_id= l_t_version_id;
757:

Line 7933: FROM pa_fin_plan_types_vl fin,

7929: ,NVL(pfo.approved_cost_plan_type_flag,'N') approved_cost_plan_type_flag
7930: ,NVL(pfo.approved_rev_plan_type_flag,'N') approved_rev_plan_type_flag
7931: ,fin.plan_class_code
7932: ,pfo.fin_plan_preference_code
7933: FROM pa_fin_plan_types_vl fin,
7934: pa_proj_fp_options pfo
7935: WHERE pfo.project_id = p_project_id
7936: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7937: AND pfo.fin_plan_type_id = fin.fin_plan_type_id