APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_ELEMENTS

Line 465: -- delete from PA_FP_ELEMENTS

461: END LOOP;
462: CLOSE fp_options_cur;
463: -- End of changes for Bug 3619687
464:
465: -- delete from PA_FP_ELEMENTS
466:
467: /*
468: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id
469: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids

Line 468: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id

464:
465: -- delete from PA_FP_ELEMENTS
466:
467: /*
468: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id
469: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
470: */
471:
472: /* commented for bug 10305516

Line 473: delete from pa_fp_elements e

469: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
470: */
471:
472: /* commented for bug 10305516
473: delete from pa_fp_elements e
474: where e.proj_fp_options_id in (select o.proj_fp_options_id from pa_proj_fp_options o
475: where o.project_id = p_project_id and
476: o.fin_plan_type_id = p_fin_plan_type_id);
477: */

Line 490: DELETE from pa_fp_elements

486: FROM pa_proj_fp_options
487: WHERE project_id = p_project_id and fin_plan_type_id = p_fin_plan_type_id;
488:
489: FORALL i IN x_proj_fp_options_id_array.first..x_proj_fp_options_id_array.last
490: DELETE from pa_fp_elements
491: WHERE proj_fp_options_id = x_proj_fp_options_id_array(i);
492:
493: -- delete from PA_FP_TXN_CURRENCIES
494: delete from pa_fp_txn_currencies tc