693: -- Get Balance Type Ids
694: cursor c_balance_type_id(cp_ele_name varchar2,
695: cp_business_grp_id number) IS
696: select balance_type_id
697: from pay_balance_types
698: where business_group_id = cp_business_grp_id
699: and balance_name in (cp_ele_name,
700: cp_ele_name || ' Accrued',
701: cp_ele_name || ' Accrued Fees',
881: */
882: delete
883: from pay_balance_feeds_f
884: where balance_type_id in (select balance_type_id
885: from pay_balance_types
886: where balance_name in
887: (p_new_ele_name,
888: p_new_ele_name || ' Accrued',
889: p_new_ele_name || ' Accrued Fees',