APPS.HR_ELEMENTS dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 975: from pay_sub_classification_rules_f

971: p_classification number,
972: p_business_group_id number,
973: p_legislation_code varchar2) IS
974: select 'X'
975: from pay_sub_classification_rules_f
976: where effective_start_date = p_start_date
977: and effective_end_date = p_end_date
978: and element_type_id = p_element_type_id
979: and classification_id = p_classification

Line 1021: insert into pay_sub_classification_rules_f

1017: from dual;
1018: --
1019: -- Insert sub_classification rule.
1020: --
1021: insert into pay_sub_classification_rules_f
1022: (SUB_CLASSIFICATION_RULE_ID
1023: ,EFFECTIVE_START_DATE
1024: ,EFFECTIVE_END_DATE
1025: ,ELEMENT_TYPE_ID

Line 1334: from pay_sub_classification_rules_f scr

1330: delete from hr_application_ownerships ao
1331: where ao.key_name = 'SUB_CLASSIFICATION_RULE_ID'
1332: and exists
1333: (select 1
1334: from pay_sub_classification_rules_f scr
1335: where scr.element_type_id = p_element_type_id
1336: and ao.key_value =
1337: to_char(scr.sub_classification_rule_id));
1338: --

Line 1341: delete from pay_sub_classification_rules_f

1337: to_char(scr.sub_classification_rule_id));
1338: --
1339: end if;
1340: --
1341: delete from pay_sub_classification_rules_f
1342: where element_type_id = p_element_type_id;
1343: --
1344: elsif p_delete_mode = 'DELETE' then
1345: --

Line 1352: delete from pay_sub_classification_rules_f

1348: hr_utility.set_location('hr_elements.del_sub_classification_rules', 2);
1349: end if;
1350: --
1351: -- delete all future records
1352: delete from pay_sub_classification_rules_f
1353: where element_type_id = p_element_type_id
1354: and effective_start_date > p_val_session_date;
1355: --
1356: -- update current records so that the end date is the session date

Line 1357: update pay_sub_classification_rules_f

1353: where element_type_id = p_element_type_id
1354: and effective_start_date > p_val_session_date;
1355: --
1356: -- update current records so that the end date is the session date
1357: update pay_sub_classification_rules_f
1358: set effective_end_date = p_val_session_date
1359: where element_type_id = p_element_type_id
1360: and p_val_session_date between
1361: effective_start_date and effective_end_date;