APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 1301: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

1297: --End of variables used for debugging
1298:
1299: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1300: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1301: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1302: l_rlm_id_tbl_count NUMBER := 0;
1303: l_elem_version_id_count NUMBER := 0;
1304: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1305: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

Line 2125: FROM pa_fin_plan_types_b

2121: END IF;
2122:
2123: SELECT fin_plan_type_id
2124: INTO l_fin_plan_type_id
2125: FROM pa_fin_plan_types_b
2126: WHERE use_for_workplan_flag ='Y';
2127:
2128: pa_fin_plan_pub.Create_Version (
2129: p_project_id => p_project_id

Line 10020: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;

10016: l_proj_wp_type_exists NUMBER :=0;
10017: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10018: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10019: l_proj_currency_code pa_projects_all.project_currency_code%type;
10020: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10021:
10022: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
10023: l_src_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10024: BEGIN

Line 10072: FROM pa_fin_plan_types_b

10068: BEGIN -- BLOCK to check if workplan_type is is present in the system- Starts
10069:
10070: SELECT fin_plan_type_id,approved_rev_plan_type_flag
10071: INTO l_wp_type_id,l_appr_rev_plan_type_flag
10072: FROM pa_fin_plan_types_b
10073: WHERE nvl(use_for_workplan_flag,'N') = 'Y';
10074:
10075: EXCEPTION
10076:

Line 11391: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

11387: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11388: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
11389: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11390:
11391: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11392:
11393: BEGIN
11394: FND_MSG_PUB.initialize;
11395: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 11492: FROM pa_fin_plan_types_b

11488:
11489: BEGIN
11490: SELECT plan_class_code
11491: INTO l_plan_class_code
11492: FROM pa_fin_plan_types_b
11493: where fin_plan_type_id = version_info_rec.fin_plan_type_id;
11494:
11495: EXCEPTION
11496: WHEN OTHERS THEN

Line 11808: ,pa_fin_plan_types_b fpt

11804: ,pfo.cost_non_labor_res_rate_sch_id
11805: ,pfo.cost_res_class_rate_sch_id
11806: ,pfo.cost_burden_rate_sch_id
11807: FROM pa_proj_fp_options pfo
11808: ,pa_fin_plan_types_b fpt
11809: WHERE pfo.project_id = p_project_id
11810: AND pfo.fin_plan_type_id = fpt.fin_plan_type_id
11811: AND fpt.use_for_workplan_flag = 'Y'
11812: AND pfo.fin_plan_option_level_code = 'PLAN_TYPE';