700: -- Get Balance Type Ids
701: cursor c_balance_type_id(cp_ele_name varchar2,
702: cp_business_grp_id number) IS
703: select balance_type_id
704: from pay_balance_types
705: where business_group_id = cp_business_grp_id
706: and balance_name in (cp_ele_name,
707: cp_ele_name || ' Accrued',
708: cp_ele_name || ' Accrued Fees',
888: */
889: delete
890: from pay_balance_feeds_f
891: where balance_type_id in (select balance_type_id
892: from pay_balance_types
893: where balance_name in
894: (p_new_ele_name,
895: p_new_ele_name || ' Accrued',
896: p_new_ele_name || ' Accrued Fees',