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

Line 16: l_legislation_code per_business_groups.legislation_code%type;

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

Line 25: per_business_groups bgp

21: )
22: IS
23: SELECT bgp.legislation_code
24: FROM per_people_f per,
25: per_business_groups bgp
26: WHERE per.business_group_id = bgp.business_group_id
27: AND per.person_id = l_person_id
28: AND l_effective_date between per.effective_start_date and per.effective_END_date;
29: