DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 5046: FROM pay_ele_payroll_freq_rules

5042: v_refund_ele_id pay_element_types_f.element_type_id%TYPE;
5043:
5044: CURSOR get_freqrule IS
5045: SELECT ele_payroll_freq_rule_id
5046: FROM pay_ele_payroll_freq_rules
5047: WHERE element_type_id = p_ele_type_id
5048: AND business_group_id = p_business_group_id;
5049:
5050: CURSOR get_formulae(l_ele_id in number) IS

Line 5360: DELETE FROM pay_ele_payroll_freq_rules

5356: end;
5357:
5358: begin
5359:
5360: DELETE FROM pay_ele_payroll_freq_rules
5361: WHERE ele_payroll_freq_rule_id = v_freqrule_id;
5362:
5363: exception when NO_DATA_FOUND then
5364: null; -- No freq rule exists.