[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
1338: from hr_s_sub_classn_rules_f hscr
1339: where hscr.sub_classification_rule_id = v_new_sub_class_id
1340: and exists
1341: ( select 1
1342: from pay_sub_classification_rules_f pscr
1343: where pscr.element_type_id = hscr.element_type_id
1344: and pscr.classification_id = hscr.classification_id
1345: and nvl(pscr.business_group_id, -1) = nvl(hscr.business_group_id, -1)
1346: and nvl(pscr.legislation_code, 'X') = nvl(hscr.legislation_code, 'X')
2012: -- Deletes rows from a live account in readiness for them to be installed
2013:
2014: BEGIN
2015:
2016: delete from pay_sub_classification_rules_f
2017: where element_type_id = r_distinct.c_surrogate_key
2018: and business_group_id is null;
2019:
2020: delete from pay_formula_result_rules_f a
2426: from pay_element_classifications
2427: where classification_id = s_rules.classification_id;
2428:
2429: BEGIN
2430: insert into pay_sub_classification_rules_f
2431: (sub_classification_rule_id
2432: ,effective_start_date
2433: ,effective_end_date
2434: ,element_type_id
2456: ,s_rules.creation_date
2457: );
2458: EXCEPTION WHEN OTHERS THEN
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('ins pay_sub_classification_rules_f');
2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||
2464: to_char(s_rules.element_type_id));