APPS.HR_ELEMENTS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 524: from pay_status_processing_rules_f spr,

520: select 'N'
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

Line 558: from pay_status_processing_rules_f spr,

554: select 'N'
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

Line 1227: from pay_status_processing_rules_f

1223: p_val_end_date date) is
1224: select status_processing_rule_id,
1225: effective_start_date,
1226: effective_end_date
1227: from pay_status_processing_rules_f
1228: where p_element_type_id = element_type_id
1229: and effective_start_date <= p_val_end_date
1230: and effective_end_date >= p_val_start_date
1231: for update;

Line 1261: from pay_status_processing_rules_f spr

1257: delete from hr_application_ownerships ao
1258: where ao.key_name = 'STATUS_PROCESSING_RULE_ID'
1259: and exists
1260: (select 1
1261: from pay_status_processing_rules_f spr
1262: where spr.element_type_id = p_element_type_id
1263: and ao.key_value =
1264: to_char(spr.status_processing_rule_id));
1265: end if;

Line 1267: delete from pay_status_processing_rules_f

1263: and ao.key_value =
1264: to_char(spr.status_processing_rule_id));
1265: end if;
1266: --
1267: delete from pay_status_processing_rules_f
1268: where element_type_id = p_element_type_id;
1269: --
1270: elsif p_delete_mode = 'DELETE' then
1271: --

Line 1277: delete from pay_status_processing_rules_f

1273: hr_utility.set_location('hr_elements.del_status_processing_rules', 2);
1274: end if;
1275: --
1276: -- delete all future records
1277: delete from pay_status_processing_rules_f
1278: where element_type_id = p_element_type_id
1279: and effective_start_date > p_val_session_date;
1280: --
1281: -- update current records so that the end date is the session date

Line 1282: update pay_status_processing_rules_f

1278: where element_type_id = p_element_type_id
1279: and effective_start_date > p_val_session_date;
1280: --
1281: -- update current records so that the end date is the session date
1282: update pay_status_processing_rules_f
1283: set effective_end_date = p_val_session_date
1284: where element_type_id = p_element_type_id
1285: and p_val_session_date between
1286: effective_start_date and effective_end_date;