eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CHANGE_START_DATE_API dependencies on PER_BUSINESS_GROUPS

Line 2021: ,per_business_groups bus

2017: ,p_effective_date IN DATE
2018: ) IS
2019: SELECT bus.legislation_code
2020: FROM per_people_f per
2021: ,per_business_groups bus
2022: WHERE per.person_id = csr_legislation.p_person_id
2023: AND per.business_group_id+0 = bus.business_group_id
2024: AND csr_legislation.p_effective_date BETWEEN per.effective_start_date
2025: AND per.effective_end_date;

Line 2027: l_legislation_code per_business_groups.legislation_code%TYPE;

2023: AND per.business_group_id+0 = bus.business_group_id
2024: AND csr_legislation.p_effective_date BETWEEN per.effective_start_date
2025: AND per.effective_end_date;
2026: --
2027: l_legislation_code per_business_groups.legislation_code%TYPE;
2028: l_hd_rule_value pay_legislation_rules.rule_mode%TYPE;
2029: l_hd_rule_found BOOLEAN;
2030: l_fpd_rule_value pay_legislation_rules.rule_mode%TYPE;
2031: l_fpd_rule_found BOOLEAN;