DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 1562: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options

1558: and b.pm_product_code is not NULL;
1559: c_people_res_rec c_people_res_check%ROWTYPE;
1560:
1561: CURSOR C_Workplan_Costs_enabled(p_budget_version_id IN NUMBER) IS
1562: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options
1563: where fin_plan_version_id = p_budget_version_id;
1564: C_Workplan_costs_rec C_Workplan_Costs_enabled%ROWTYPE;
1565:
1566: CURSOR C_Check_Res_List_None (c_resource_list_id IN NUMBER) IS

Line 3974: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; --8429604

3970: l_fixed_date DATE;
3971: l_spread_curve_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
3972: l_spread_curve_code pa_spread_curves_b.spread_curve_code%TYPE ;
3973: l_fixed_date_tbl system.pa_date_tbl_type :=system.pa_date_tbl_type();
3974: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; --8429604
3975: --Bug#8646853 -Addition end
3976:
3977: --Bug#9374037
3978: CURSOR C_Proj_Ass_Id(p_resource_assignment_id IN NUMBER) IS

Line 4205: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options

4201: c_people_res_rec c_people_res_check%ROWTYPE;
4202:
4203:
4204: CURSOR C_Workplan_Costs_enabled(p_budget_version_id IN NUMBER) IS
4205: select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options
4206: where fin_plan_version_id = p_budget_version_id;
4207: C_Workplan_costs_rec C_Workplan_Costs_enabled%ROWTYPE;
4208:
4209: l_valid_member_flag varchar2(1);