APPS.PA_FIN_PLAN_TYPE_GLOBAL dependencies on PA_FP_TXN_CURRENCIES

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

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: /*
446: Bug 3106741 For pa_fp_txn_currencies there is no index avaialable on project_id and plan_type_id
447: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
448: */
449:
450: -- delete from PA_FP_TXN_CURRENCIES

Line 450: -- delete from PA_FP_TXN_CURRENCIES

446: Bug 3106741 For pa_fp_txn_currencies there is no index avaialable on project_id and plan_type_id
447: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
448: */
449:
450: -- delete from PA_FP_TXN_CURRENCIES
451: delete from pa_fp_txn_currencies tc
452: where tc.proj_fp_options_id in (select o.proj_fp_options_id
453: from pa_proj_fp_options o
454: where o.project_id = p_project_id and --Replaced project_id with p_project_id

Line 451: delete from pa_fp_txn_currencies tc

447: to avoid full table scan pa_proj_fp_options would be used to fetch all the relevant option_ids
448: */
449:
450: -- delete from PA_FP_TXN_CURRENCIES
451: delete from pa_fp_txn_currencies tc
452: where tc.proj_fp_options_id in (select o.proj_fp_options_id
453: from pa_proj_fp_options o
454: where o.project_id = p_project_id and --Replaced project_id with p_project_id
455: --for bug 2740553