APPS.PA_FP_WEBADI_UTILS dependencies on PA_FIN_PLAN_TYPES_B

Line 41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;

Line 107: ,pa_fin_plan_types_b ptb

103: ,l_revenue_layout_code
104: ,l_all_layout_code
105: ,l_plan_class_code
106: FROM pa_proj_fp_options pfo
107: ,pa_fin_plan_types_b ptb
108: WHERE pfo.fin_plan_type_id = l_fin_plan_type_id
109: AND pfo.FIN_PLAN_version_id IS NULL
110: AND pfo.fin_plan_type_id = ptb.fin_plan_type_id
111: AND pfo.project_id = l_project_id;