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_IN_PERSON_ADDRESS_API dependencies on PER_BUSINESS_GROUPS

Line 15: l_legislation_code per_business_groups.legislation_code%type;

11: ,p_legislation_code IN VARCHAR2
12: ,p_effective_date IN DATE
13: )
14: IS
15: l_legislation_code per_business_groups.legislation_code%type;
16: --
17: CURSOR csr_emp_leg
18: (c_person_id per_people_f.person_id%TYPE,
19: c_effective_date DATE

Line 24: per_business_groups bgp

20: )
21: IS
22: select bgp.legislation_code
23: from per_people_f per,
24: per_business_groups bgp
25: where per.business_group_id = bgp.business_group_id
26: and per.person_id = c_person_id
27: and c_effective_date between per.effective_start_date and per.effective_END_date;
28: