APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_RBS_VERSIONS_B

Line 282: CURSOR get_rbs_header_id_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE) IS

278: AND fin_plan_type_id=c_fin_plan_type_id
279: and fin_plan_option_level_code = 'PLAN_TYPE';
280:
281: --Bug#11776072 - cusror to get rbs_header_id
282: CURSOR get_rbs_header_id_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE) IS
283: SELECT rbs_header_id
284: FROM pa_rbs_versions_b
285: WHERE rbs_version_id=c_rbs_version_id;
286:

Line 284: FROM pa_rbs_versions_b

280:
281: --Bug#11776072 - cusror to get rbs_header_id
282: CURSOR get_rbs_header_id_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE) IS
283: SELECT rbs_header_id
284: FROM pa_rbs_versions_b
285: WHERE rbs_version_id=c_rbs_version_id;
286:
287: --Bug#11776072 - cusror to check rbs association in the project
288: CURSOR check_association_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE , c_project_id NUMBER) IS

Line 288: CURSOR check_association_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE , c_project_id NUMBER) IS

284: FROM pa_rbs_versions_b
285: WHERE rbs_version_id=c_rbs_version_id;
286:
287: --Bug#11776072 - cusror to check rbs association in the project
288: CURSOR check_association_cur(c_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE , c_project_id NUMBER) IS
289: SELECT 'X'
290: FROM pa_proj_fp_options
291: WHERE rbs_version_id = c_rbs_version_id
292: AND project_id=c_project_id

Line 311: l_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE;

307: TYPE x_proj_fp_options_id is table of pa_proj_fp_options.proj_fp_options_id%type;
308: x_proj_fp_options_id_array x_proj_fp_options_id;
309:
310: --Bug#11776072
311: l_rbs_version_id pa_rbs_versions_b.rbs_version_id%TYPE;
312: l_rbs_header_id pa_rbs_headers_b.rbs_header_id%TYPE;
313: l_exists_association VARCHAR2(1);
314:
315: BEGIN