APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_ELEMENTS

Line 434: -- delete from PA_FP_ELEMENTS

430: END LOOP;
431: CLOSE fp_options_cur;
432: -- End of changes for Bug 3619687
433:
434: -- delete from PA_FP_ELEMENTS
435:
436: /*
437: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id
438: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids

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

433:
434: -- delete from PA_FP_ELEMENTS
435:
436: /*
437: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id
438: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
439: */
440:
441: delete from pa_fp_elements e

Line 441: delete from pa_fp_elements e

437: Bug 3106741 For pa_fp_elements there is no index avaialable on project_id and plan_type_id
438: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
439: */
440:
441: delete from pa_fp_elements e
442: where e.proj_fp_options_id in (select o.proj_fp_options_id from pa_proj_fp_options o
443: where o.project_id = p_project_id and
444: o.fin_plan_type_id = p_fin_plan_type_id);
445: /*