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_KW_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 249: (c_previous_employer_id per_previous_employers.previous_employer_id%TYPE,

245: l_discard_varchar2 varchar2(30);
246: --
247:
248: cursor check_legislation
249: (c_previous_employer_id per_previous_employers.previous_employer_id%TYPE,
250: c_effective_date date
251: )
252: is
253: select bgp.legislation_code

Line 256: per_previous_employers pem

252: is
253: select bgp.legislation_code
254: from per_people_f per,
255: per_business_groups bgp,
256: per_previous_employers pem
257: where per.business_group_id = bgp.business_group_id
258: and per.person_id = pem.person_id
259: and pem.previous_employer_id = c_previous_employer_id
260: and c_effective_date