APPS.HR_ELEMENTS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 449: from pay_formula_result_rules_f frr,

445: into v_validation_check
446: from sys.dual
447: where exists
448: (select 1
449: from pay_formula_result_rules_f frr,
450: pay_input_values_f iv
451: where p_element_type_id = iv.element_type_id
452: and iv.input_value_id = frr.input_value_id
453: and frr.effective_start_date <= p_val_end_date

Line 525: pay_formula_result_rules_f fr,

521: into v_validation_check
522: from sys.dual
523: where exists (select 1
524: from pay_status_processing_rules_f spr,
525: pay_formula_result_rules_f fr,
526: pay_input_values_f iv,
527: pay_element_types_f et
528: where spr.element_type_id = p_element_type_id
529: and fr.result_rule_type = 'I'

Line 559: pay_formula_result_rules_f fr,

555: into v_validation_check
556: from sys.dual
557: where exists(select 1
558: from pay_status_processing_rules_f spr,
559: pay_formula_result_rules_f fr,
560: pay_input_values_f iv,
561: pay_element_types_f et
562: where fr.input_value_id = iv.input_value_id
563: and fr.result_rule_type = 'I'

Line 1165: from pay_formula_result_rules_f frr

1161: delete from hr_application_ownerships ao
1162: where key_name = 'FORMULA_RESULT_RULE_ID'
1163: and exists
1164: (select 1
1165: from pay_formula_result_rules_f frr
1166: where frr.status_processing_rule_id =
1167: p_status_processing_rule_id
1168: and ao.key_value = to_char(frr.formula_result_rule_id));
1169: --

Line 1172: delete from pay_formula_result_rules_f

1168: and ao.key_value = to_char(frr.formula_result_rule_id));
1169: --
1170: end if;
1171: --
1172: delete from pay_formula_result_rules_f
1173: where status_processing_rule_id = p_status_processing_rule_id;
1174: --
1175: elsif p_delete_mode = 'DELETE' then
1176: --

Line 1182: delete from pay_formula_result_rules_f

1178: hr_utility.set_location('hr_elements.del_formula_result_rules', 2);
1179: end if;
1180: --
1181: -- delete all future records
1182: delete from pay_formula_result_rules_f
1183: where status_processing_rule_id = p_status_processing_rule_id
1184: and effective_start_date > p_val_session_date;
1185: --
1186: -- update current records so that the end date is the session date

Line 1187: update pay_formula_result_rules_f

1183: where status_processing_rule_id = p_status_processing_rule_id
1184: and effective_start_date > p_val_session_date;
1185: --
1186: -- update current records so that the end date is the session date
1187: update pay_formula_result_rules_f
1188: set effective_end_date = p_val_session_date
1189: where status_processing_rule_id = p_status_processing_rule_id
1190: and p_val_session_date between
1191: effective_start_date and effective_end_date;