APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_SPREAD_CURVES_B

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

128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

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

1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1374: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1375: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2506: from pa_spread_curves_b

2502: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2503: END IF;
2504: Select spread_curve_id
2505: into l_fixed_date_sp_id
2506: from pa_spread_curves_b
2507: where spread_curve_code = 'FIXED_DATE';
2508:
2509: IF l_debug_mode = 'Y' THEN
2510: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;

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

6080: l_loop_end NUMBER;
6081:
6082: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
6083: l_project_id pa_projects_all.project_id%TYPE;
6084: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
6085: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
6086:
6087: l_job_id_temp NUMBER; --bug#13566990
6088:

Line 6647: from pa_spread_curves_b

6643: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6644: END IF;
6645: Select spread_curve_id
6646: into l_fixed_date_sp_id
6647: from pa_spread_curves_b
6648: where spread_curve_code = 'FIXED_DATE';
6649:
6650: IF l_debug_mode = 'Y' THEN
6651: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;