APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_EXCLUDED_ELEMENTS

Line 458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also

454: where o.project_id = p_project_id and --Replaced project_id with p_project_id
455: --for bug 2740553
456: o.fin_plan_type_id = p_fin_plan_type_id);
457:
458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);

Line 461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';

457:
458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
463: END IF;
464:
465: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take

Line 466: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */

462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
463: END IF;
464:
465: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
466: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */
467:
468: DELETE
469: FROM pa_fp_excluded_elements ee
470: WHERE ee.proj_fp_options_id IN (SELECT pfo.proj_fp_options_id

Line 469: FROM pa_fp_excluded_elements ee

465: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
466: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */
467:
468: DELETE
469: FROM pa_fp_excluded_elements ee
470: WHERE ee.proj_fp_options_id IN (SELECT pfo.proj_fp_options_id
471: FROM pa_proj_fp_options pfo
472: WHERE pfo.project_id = p_project_id
473: AND pfo.fin_plan_type_id=p_fin_plan_type_id);