APPS.PER_PL_PEM_INFO dependencies on PER_PREVIOUS_EMPLOYERS

Line 245: select ppj.pjo_information1 from per_previous_employers ppe, per_previous_jobs ppj

241: p_employment_category VARCHAR2,
242: p_pjo_information1 VARCHAR2) IS
243:
244: cursor csr_emp_catupd is
245: select ppj.pjo_information1 from per_previous_employers ppe, per_previous_jobs ppj
246: where
247: ppe.previous_employer_id = ppj.previous_employer_id and
248: ppj.previous_job_id <> p_previous_job_id and ppj.previous_employer_id in (
249: select previous_employer_id from per_previous_jobs where previous_job_id = p_previous_job_id);