DBA Data[Home] [Help]

APPS.HR_US_GARN_GEN dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 5044: FROM pay_ele_payroll_freq_rules

5040: WHERE element_type_id = l_ele_id;
5041:
5042: CURSOR get_freqrule IS
5043: SELECT ele_payroll_freq_rule_id
5044: FROM pay_ele_payroll_freq_rules
5045: WHERE element_type_id = p_ele_type_id;
5046:
5047: -- Bug 3682501
5048: -- Cursor to obtain the template id needed to be deleted from the shadow tables

Line 5223: DELETE FROM pay_ele_payroll_freq_rules

5219: end;
5220:
5221: begin
5222:
5223: DELETE FROM pay_ele_payroll_freq_rules
5224: WHERE ele_payroll_freq_rule_id = v_freqrule_id;
5225:
5226: exception when NO_DATA_FOUND then
5227: null; -- No freq rule exists.