4916: v_assoc_ele_priority number(9);
4917:
4918: CURSOR get_freqrule IS
4919: SELECT ele_payroll_freq_rule_id
4920: FROM pay_ele_payroll_freq_rules
4921: WHERE element_type_id = p_ele_type_id
4922: AND business_group_id = p_business_group_id;
4923:
4924: CURSOR get_formulae(l_ele_id in number) IS
5197: end;
5198:
5199: begin
5200:
5201: DELETE FROM pay_ele_payroll_freq_rules
5202: WHERE ele_payroll_freq_rule_id = v_freqrule_id;
5203:
5204: exception when NO_DATA_FOUND then
5205: null; -- No freq rule exists.