APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_SPREAD_CURVES_B

Line 76: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061

72: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
73: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
74: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
75: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
76: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
77: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
78: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
79: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
80: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 1312: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061

1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1310: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1311: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1312: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1313:
1314: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1315: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1316: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2278: from pa_spread_curves_b

2274: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2275: END IF;
2276: Select spread_curve_id
2277: into l_fixed_date_sp_id
2278: from pa_spread_curves_b
2279: where spread_curve_code = 'FIXED_DATE';
2280:
2281: IF l_debug_mode = 'Y' THEN
2282: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;

Line 5428: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061

5424: l_loop_end NUMBER;
5425:
5426: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5427: l_project_id pa_projects_all.project_id%TYPE;
5428: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
5429: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
5430:
5431:
5432: /* Start of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS

Line 5977: from pa_spread_curves_b

5973: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5974: END IF;
5975: Select spread_curve_id
5976: into l_fixed_date_sp_id
5977: from pa_spread_curves_b
5978: where spread_curve_code = 'FIXED_DATE';
5979:
5980: IF l_debug_mode = 'Y' THEN
5981: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;