APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 948: from pay_formula_result_rules_f a

944:
945:
946: select distinct null
947: into l_null_return
948: from pay_formula_result_rules_f a
949: where exists
950: (select null
951: from hr_s_formula_result_rules_f b
952: where a.formula_result_rule_id = b.formula_result_rule_id

Line 1519: , pay_formula_result_rules_f b

1515:
1516: select distinct null
1517: into l_null_return
1518: from pay_status_processing_rules_f a
1519: , pay_formula_result_rules_f b
1520: where a.element_type_id = l_new_element_type_id
1521: and b.status_processing_rule_id = a.status_processing_rule_id
1522: and b.effective_end_Date > r_distinct.c_end
1523: and b.business_group_id is not null;

Line 2020: delete from pay_formula_result_rules_f a

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
2021: where a.business_group_id is null
2022: and exists
2023: (select null
2024: from pay_status_processing_rules_f b

Line 2564: insert into pay_formula_result_rules_f

2560:
2561: FOR all_frrs IN frrs(p_rules.s_rule_id) LOOP
2562:
2563: BEGIN
2564: insert into pay_formula_result_rules_f
2565: (FORMULA_RESULT_RULE_ID
2566: ,EFFECTIVE_START_DATE
2567: ,EFFECTIVE_END_DATE
2568: ,BUSINESS_GROUP_ID

Line 2604: hr_utility.trace('ins pay_formula_result_rules_f');

2600: ,all_frrs.CREATION_DATE
2601: );
2602: EXCEPTION WHEN OTHERS THEN
2603: hr_legislation.hrrunprc_trace_on;
2604: hr_utility.trace('ins pay_formula_result_rules_f');
2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2608: to_char(all_frrs.STATUS_PROCESSING_RULE_ID));