DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 1855: from per_previous_employers ppe,

1851: ppe.start_date,
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