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.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_PREVIOUS_JOBS

Line 1856: per_previous_jobs ppj

1852: ppe.end_date,
1853: ppj.job_name,
1854: ppj.employment_category
1855: from per_previous_employers ppe,
1856: per_previous_jobs ppj
1857: where ppe.person_id = l_person_id
1858: and nvl(ppe.start_date,l_hire_date - 1) < l_hire_date
1859: and ppj.previous_employer_id (+) = ppe.previous_employer_id
1860: and nvl(ppj.start_date,l_hire_date - 1) < l_hire_date

Line 1863: from per_previous_jobs ppj2

1859: and ppj.previous_employer_id (+) = ppe.previous_employer_id
1860: and nvl(ppj.start_date,l_hire_date - 1) < l_hire_date
1861: and not exists(
1862: select null
1863: from per_previous_jobs ppj2
1864: where ppj2.previous_employer_id = ppj.previous_employer_id
1865: and ((nvl(ppj2.start_date,l_hire_date) = nvl(ppj.start_date,l_hire_date)
1866: and nvl(ppj2.end_date,l_hire_date) = nvl(ppj.end_date,l_hire_date)
1867: and ppj2.previous_job_id > ppj.previous_job_id)