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

Line 250: (c_previous_employer_id per_previous_employers.previous_employer_id%TYPE,

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

Line 257: per_previous_employers pem

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