APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_BUDGET_TYPES

Line 101: FROM pa_budget_types a, pa_fin_plan_types_b b

97: /*Commented out the sql for bug 2774573 */
98: /*
99: SELECT 'Y'
100: INTO l_exists
101: FROM pa_budget_types a, pa_fin_plan_types_b b
102: WHERE upper(budget_type) = upper(p_name)
103: AND b.fin_plan_type_id = p_fin_plan_type_id
104: AND a.budget_type_code <> b.migrated_frm_bdgt_typ_code;
105: */

Line 113: FROM pa_budget_types a

109: 1. updating an upgraded plan type
110: */
111: SELECT 'Y'
112: INTO l_exists
113: FROM pa_budget_types a
114: WHERE upper(a.budget_type) = upper(p_name)
115: AND NOT EXISTS( SELECT 'x'
116: FROM pa_fin_plan_types_b f
117: WHERE f.fin_plan_type_id=p_fin_plan_type_id