APPS.PER_PL_PEM_INFO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 141

PROCEDURE UPDATE_PL_PREV_EMPLOYER(p_effective_date           DATE,
                                  p_previous_employer_id     NUMBER,
                                  p_start_date               DATE,
                                  p_end_date                 DATE,
                                  p_period_years             NUMBER,
                                  p_period_months            NUMBER,
                                  p_period_days              NUMBER,
                                  p_employer_type            VARCHAR2,
                                  p_employer_name            VARCHAR2,
                                  p_employer_subtype         VARCHAR2,
                                  p_pem_information_category VARCHAR2,
                                  p_pem_information1         VARCHAR2,
                                  p_pem_information2         VARCHAR2,
                                  p_pem_information3         VARCHAR2,
                                  p_pem_information4         VARCHAR2,
                                  p_pem_information5         VARCHAR2,
                                  p_pem_information6         VARCHAR2) IS

l_proc varchar2(72);

Line: 163

l_proc := 'PER_PL_PEM_INFO.'||'UPDATE_PL_PREV_EMPLOYER';

Line: 188

END UPDATE_PL_PREV_EMPLOYER;

Line: 201

    select 1 from per_previous_jobs where previous_employer_id = p_previous_employer_id
    and pjo_information1 = p_pjo_information1;

Line: 234

PROCEDURE UPDATE_PL_PREV_JOB(p_effective_date       DATE,
                             p_previous_job_id      NUMBER,
                             p_start_date           DATE,
                             p_end_date             DATE,
                             p_period_years         NUMBER,
                             p_period_months        NUMBER,
                             p_period_days          NUMBER,
                             p_employment_category  VARCHAR2,
                             p_pjo_information1     VARCHAR2) IS

cursor csr_emp_catupd is
select ppj.pjo_information1 from per_previous_employers ppe, per_previous_jobs ppj
       where
         ppe.previous_employer_id = ppj.previous_employer_id and
         ppj.previous_job_id <> p_previous_job_id and ppj.previous_employer_id in (
		 select previous_employer_id from per_previous_jobs where previous_job_id = p_previous_job_id);

Line: 258

   hr_utility.trace('PL not installed.Leaving UPDATE_PL_PREV_JOB');

Line: 281

END UPDATE_PL_PREV_JOB;