APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_TXN_CURRENCIES

Line 479: Bug 3106741 For pa_fp_txn_currencies there is no index avaialable on project_id and plan_type_id

475: where o.project_id = p_project_id and
476: o.fin_plan_type_id = p_fin_plan_type_id);
477: */
478: /*
479: Bug 3106741 For pa_fp_txn_currencies there is no index avaialable on project_id and plan_type_id
480: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
481: */
482:
483: -- Bug 10305516 skkoppul: replaced above delete statement with following 2 statements

Line 493: -- delete from PA_FP_TXN_CURRENCIES

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
495: where tc.proj_fp_options_id in (select o.proj_fp_options_id
496: from pa_proj_fp_options o
497: where o.project_id = p_project_id and --Replaced project_id with p_project_id

Line 494: delete from pa_fp_txn_currencies tc

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
495: where tc.proj_fp_options_id in (select o.proj_fp_options_id
496: from pa_proj_fp_options o
497: where o.project_id = p_project_id and --Replaced project_id with p_project_id
498: --for bug 2740553