APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_EXCLUDED_ELEMENTS

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

497: where o.project_id = p_project_id and --Replaced project_id with p_project_id
498: --for bug 2740553
499: o.fin_plan_type_id = p_fin_plan_type_id);
500:
501: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
502:
503: IF P_PA_DEBUG_MODE = 'Y' THEN
504: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);

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

500:
501: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
502:
503: IF P_PA_DEBUG_MODE = 'Y' THEN
504: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
506: END IF;
507:
508: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take

Line 509: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */

505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
506: END IF;
507:
508: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
509: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */
510:
511: DELETE
512: FROM pa_fp_excluded_elements ee
513: WHERE ee.proj_fp_options_id IN (SELECT pfo.proj_fp_options_id

Line 512: FROM pa_fp_excluded_elements ee

508: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
509: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */
510:
511: DELETE
512: FROM pa_fp_excluded_elements ee
513: WHERE ee.proj_fp_options_id IN (SELECT pfo.proj_fp_options_id
514: FROM pa_proj_fp_options pfo
515: WHERE pfo.project_id = p_project_id
516: AND pfo.fin_plan_type_id=p_fin_plan_type_id);