APPS.HR_CHANGE_START_DATE_API dependencies on PER_BUSINESS_GROUPS

Line 2470: ,per_business_groups bus

2466: ,p_effective_date IN DATE
2467: ) IS
2468: SELECT bus.legislation_code
2469: FROM per_people_f per
2470: ,per_business_groups bus
2471: WHERE per.person_id = csr_legislation.p_person_id
2472: AND per.business_group_id+0 = bus.business_group_id
2473: AND csr_legislation.p_effective_date BETWEEN per.effective_start_date
2474: AND per.effective_end_date;

Line 2476: l_legislation_code per_business_groups.legislation_code%TYPE;

2472: AND per.business_group_id+0 = bus.business_group_id
2473: AND csr_legislation.p_effective_date BETWEEN per.effective_start_date
2474: AND per.effective_end_date;
2475: --
2476: l_legislation_code per_business_groups.legislation_code%TYPE;
2477: l_hd_rule_value pay_legislation_rules.rule_mode%TYPE;
2478: l_hd_rule_found BOOLEAN;
2479: l_fpd_rule_value pay_legislation_rules.rule_mode%TYPE;
2480: l_fpd_rule_found BOOLEAN;