APPS.PER_PL_PEM_INFO dependencies on PER_PREVIOUS_JOBS

Line 201: select 1 from per_previous_jobs where previous_employer_id = p_previous_employer_id

197: p_employment_category VARCHAR2,
198: p_pjo_information1 VARCHAR2) IS
199:
200: cursor csr_emp_cat is
201: select 1 from per_previous_jobs where previous_employer_id = p_previous_employer_id
202: and pjo_information1 = p_pjo_information1;
203:
204:
205: dup_emp_cat number;

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);

Line 249: select previous_employer_id from per_previous_jobs where previous_job_id = p_previous_job_id);

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);
250:
251: dup_emp_cat per_previous_jobs.pjo_information1%TYPE;
252:
253:

Line 251: dup_emp_cat per_previous_jobs.pjo_information1%TYPE;

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);
250:
251: dup_emp_cat per_previous_jobs.pjo_information1%TYPE;
252:
253:
254: BEGIN
255: