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

Line 152: l_legislation_code per_business_groups.legislation_code%TYPE;

148: --
149:
150: l_proc VARCHAR2(72) := g_package||'update_nz_person';
151: l_effective_date DATE;
152: l_legislation_code per_business_groups.legislation_code%TYPE;
153: l_discard_varchar2 VARCHAR2(30);
154: --
155: CURSOR check_legislation
156: (c_person_id per_people_f.person_id%TYPE,

Line 162: per_business_groups bgp

158: )
159: IS
160: SELECT bgp.legislation_code
161: FROM per_people_f per,
162: per_business_groups bgp
163: WHERE per.business_group_id = bgp.business_group_id
164: AND per.person_id = c_person_id
165: AND c_effective_date
166: BETWEEN per.effective_start_date and per.effective_end_date;