[Home] [Help]
967:
968:
969: select distinct null
970: into l_null_return
971: from pay_sub_classification_rules_f a
972: where exists
973: (select null
974: from hr_s_sub_classn_rules_f b
975: where a.sub_classification_rule_id=b.sub_classification_rule_id
1317: from hr_s_sub_classn_rules_f hscr
1318: where hscr.sub_classification_rule_id = v_new_sub_class_id
1319: and exists
1320: ( select 1
1321: from pay_sub_classification_rules_f pscr
1322: where pscr.element_type_id = hscr.element_type_id
1323: and pscr.classification_id = hscr.classification_id
1324: and nvl(pscr.business_group_id, -1) = nvl(hscr.business_group_id, -1)
1325: and nvl(pscr.legislation_code, 'X') = nvl(hscr.legislation_code, 'X')
1980: -- Deletes rows from a live account in readiness for them to be installed
1981:
1982: BEGIN
1983:
1984: delete from pay_sub_classification_rules_f
1985: where element_type_id = r_distinct.c_surrogate_key
1986: and business_group_id is null;
1987:
1988: delete from pay_formula_result_rules_f a
2394: from pay_element_classifications
2395: where classification_id = s_rules.classification_id;
2396:
2397: BEGIN
2398: insert into pay_sub_classification_rules_f
2399: (sub_classification_rule_id
2400: ,effective_start_date
2401: ,effective_end_date
2402: ,element_type_id
2424: ,s_rules.creation_date
2425: );
2426: EXCEPTION WHEN OTHERS THEN
2427: hr_legislation.hrrunprc_trace_on;
2428: hr_utility.trace('ins pay_sub_classification_rules_f');
2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||
2432: to_char(s_rules.element_type_id));