APPS.PER_RU_PREVIOUS_EMPLOYER SQL Statements

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

Line: 9

	select 'x' from PER_PREVIOUS_EMPLOYERS
	WHERE business_group_id = p_business_group_id
	AND   person_id = p_person_id
	AND   (start_date BETWEEN P_START_DATE AND P_END_DATE
           OR end_date BETWEEN P_START_DATE AND P_END_DATE
           OR P_START_DATE BETWEEN start_date and end_date
		   OR P_END_DATE BETWEEN start_date and end_date);

Line: 18

	select 'x' from per_previous_jobs ppj, per_previous_employers ppe
	where   ppe.business_group_id=p_business_group_id
	AND     ppe.person_id=p_person_id
	AND     ppe.PREVIOUS_EMPLOYER_ID=ppj.PREVIOUS_EMPLOYER_ID
	AND     (ppj.START_DATE between p_start_date and p_end_date
        	OR ppj.end_date between p_start_date and p_end_date
	        OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date
		    OR P_END_DATE BETWEEN ppj.start_date and ppj.end_date);

Line: 28

   select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
   where a.business_group_id=p_business_group_id
   and a.person_id=p_person_id
   and a.assignment_status_type_id <> '3'
   and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
   and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
   and (effective_start_date between p_start_date and p_end_date
        OR effective_end_date between p_start_date and p_end_date
		OR p_start_date between effective_start_date and effective_end_date
		OR p_end_date between effective_start_date and effective_end_date);

Line: 80

PROCEDURE UPDATE_RU_PREVIOUS_EMPLOYER(P_PREVIOUS_EMPLOYER_ID	NUMBER
				     ,P_START_DATE		DATE
				     ,P_END_DATE		DATE
				     ,P_PEM_INFORMATION_CATEGORY VARCHAR2) is
CURSOR c_prev_employer_details is
	SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS WHERE
	(person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
	AND previous_employer_id <> P_PREVIOUS_EMPLOYER_ID
	AND   (start_date BETWEEN P_START_DATE AND P_END_DATE
	OR   end_date BETWEEN P_START_DATE AND P_END_DATE
    OR P_START_DATE BETWEEN start_date and end_date
    OR P_END_DATE BETWEEN start_date and end_date);

Line: 94

	SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
	(ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
	AND   ppe.previous_employer_id=ppj.previous_employer_id
	AND   (ppj.start_date BETWEEN P_START_DATE AND P_END_DATE
	       OR ppj.end_date BETWEEN P_START_DATE AND P_END_DATE
           OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date
		   OR P_END_DATE BETWEEN ppj.start_date and ppj.end_date);

Line: 103

   select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
   where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
   and assignment_status_type_id <> '3'
   and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
   and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
   and (effective_start_date between p_start_date and p_end_date
        OR effective_end_date between p_start_date and p_end_date
		OR p_start_date between effective_start_date and effective_end_date
		OR p_end_date between effective_start_date and effective_end_date);

Line: 152

END UPDATE_RU_PREVIOUS_EMPLOYER;

Line: 160

	select 'x' from per_previous_jobs ppj, per_previous_employers ppe
	where   (ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
	AND ppe.previous_employer_id = ppj.previous_employer_id (+)

	AND  (ppj.START_DATE between p_start_date and p_end_date
	      OR ppj.end_date between p_start_date and p_end_date
          OR ppe.START_DATE between p_start_date and p_end_date
	      OR  ppe.end_date between p_start_date and p_end_date
		  OR p_start_date between ppj.START_DATE and ppj.END_DATE
  		  OR p_end_date between ppj.START_DATE and ppj.END_DATE
  		  OR p_start_date between ppe.START_DATE and ppe.END_DATE
  		  OR p_end_date between ppe.START_DATE and ppe.END_DATE   );

Line: 174

   select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
   where (person_id,business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers WHERE previous_employer_id=p_previous_employer_id)
   and assignment_status_type_id <> '3'
   and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
   and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
   and (effective_start_date between p_start_date and p_end_date
        OR effective_end_date between p_start_date and p_end_date
		OR p_start_date between effective_start_date and effective_end_date
		OR p_end_date between effective_start_date and effective_end_date);

Line: 220

PROCEDURE UPDATE_RU_PREVIOUS_JOB(P_PREVIOUS_JOB_ID	NUMBER
				,P_START_DATE		DATE
				,P_END_DATE		DATE) is

CURSOR c_job_details is
	SELECT 'x' FROM PER_PREVIOUS_EMPLOYERS ppe, per_previous_jobs ppj WHERE
	(ppe.person_id,ppe.business_group_id) =(SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj
	WHERE ppj.previous_job_id=p_previous_job_id and ppj.previous_employer_id = pee.previous_employer_id)
	AND   ppe.previous_employer_id = ppj.previous_employer_id (+)
    AND   ppj.previous_job_id <> p_previous_job_id
	AND  (ppj.start_date BETWEEN P_START_DATE AND P_END_DATE
	      OR ppj.end_date BETWEEN P_START_DATE AND P_END_DATE
	      OR ppe.start_date BETWEEN P_START_DATE AND P_END_DATE
	      OR ppe.end_date BETWEEN P_START_DATE AND P_END_DATE
		  OR P_START_DATE BETWEEN ppj.start_date and ppj.end_date
		  OR P_END_DATE BETWEEN ppj.start_date and ppj.end_date
  		  OR P_START_DATE BETWEEN ppe.start_date and ppe.end_date
		  OR P_END_DATE BETWEEN ppe.start_date and ppe.end_date);

Line: 240

   select 'x' from per_all_assignments_f a, hr_soft_coding_keyflex s
   where (person_id, business_group_id) = (SELECT person_id,business_group_id FROM per_previous_employers pee,per_previous_jobs ppj
   WHERE ppj.previous_job_id=p_previous_job_id and ppj.previous_employer_id = pee.previous_employer_id)
   and assignment_status_type_id <> '3'
   and a.SOFT_CODING_KEYFLEX_ID = s.SOFT_CODING_KEYFLEX_ID(+)
   and (nvl(segment2, 'N') = 'N' OR a.SOFT_CODING_KEYFLEX_ID IS NULL)
   and (effective_start_date between p_start_date and p_end_date
        OR effective_end_date between p_start_date and p_end_date
		OR p_start_date between effective_start_date and effective_end_date
		OR p_end_date between effective_start_date and effective_end_date);

Line: 277

END UPDATE_RU_PREVIOUS_JOB;