eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FI_VALIDATE_PKG SQL Statements

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

Line: 18


    SELECT 'Y'
    FROM   per_person_types ppt
    WHERE  ppt.system_person_type like 'EMP%'
    AND    ppt.person_type_Id = p_person_type_id;

Line: 174


PROCEDURE qual_insert_validate
  (p_business_group_id              in      number
  ,p_qua_information_category       in      varchar2 default null
  ,p_person_id                      in      number
  ,p_qua_information1               in      varchar2 default null
  ,p_qua_information2               in      varchar2 default null
  ) IS
      l_count 	    NUMBER;

Line: 199


	select count(*)
	into l_count
	from  per_qualifications pq
        where pq.business_group_id   = p_business_group_id
	and pq.person_id    =   p_person_id
	and pq.qua_information_category='FI'
	and pq.qua_information2='Y';

Line: 212


  END qual_insert_validate;

Line: 215


PROCEDURE qual_update_validate
  (p_qua_information_category       in      varchar2 default null
  ,p_qualification_id               in      number
  ,p_qua_information1               in      varchar2 default null
  ,p_qua_information2               in      varchar2 default null
  ) IS
      l_count		        NUMBER;

Line: 226


    SELECT person_id,business_group_id
    FROM   per_qualifications
    WHERE  qualification_id = p_qualification_id;

Line: 251


	select count(*)
	into l_count
	from  per_qualifications pq
        where pq.business_group_id   = l_business_group_id
	and pq.person_id    =   l_person_id
        and pq.qualification_id <> p_qualification_id
	and pq.qua_information_category='FI'
	and pq.qua_information2='Y';

Line: 267


  END qual_update_validate ;

Line: 330


	SELECT 	 business_group_id
	FROM 	 hr_organization_units
	WHERE 	 organization_id = p_organization_id;

Line: 336


	SELECT 	COUNT(*)
	FROM 	hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
	WHERE 	o.organization_id = hoi.organization_id
	AND 	hoi.org_information_context = 'CLASS'
	AND 	hoi.org_information1 = 'FI_LOCAL_UNIT'
	AND	o.business_group_id = l_business_group_id
	AND  TO_CHAR(o.organization_id) IN
			(
			SELECT	hoinf.org_information1
			FROM	hr_organization_units org, hr_organization_information hoinf , fnd_sessions s
			WHERE	org.business_group_id = l_business_group_id
			AND	org.organization_id = hoinf.organization_id
			AND	hoinf.org_information_context = 'FI_LOCAL_UNITS'
			AND 	s.session_id = userenv('sessionid')
			AND 	s.effective_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
			)
	AND 	s.session_id = userenv('sessionid')
	AND 	s.effective_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
	AND	o.organization_id = p_org_information1;

Line: 359


	SELECT  count(*)
	FROM	hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s
	WHERE	(hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
		 hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
	AND	ou.organization_id = hoi.organization_id
	AND	ou.organization_id <> nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1  = p_org_information1 ;

Line: 369


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_TYPES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2;

Line: 379


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_TYPES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
       AND 	hoi.org_information2 IS null
       AND 	hoi.org_information3 IS null;

Line: 391


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information3 =  p_org_information3
	AND	hoi.org_information1 =  p_org_information1;

Line: 401


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
	AND 	ou.organization_id = hoi.organization_id
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2 ;

Line: 411


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information6 =  p_org_information6 ;

Line: 420


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1 ;

Line: 430


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	 (( fnd_date.canonical_to_date(p_org_information1) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( fnd_date.canonical_to_date(hoi.org_information1) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

Line: 446


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	 (( fnd_date.canonical_to_date(p_org_information1) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( fnd_date.canonical_to_date(hoi.org_information1) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));

Line: 462


	SELECT COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(p_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	trim(hoi.org_information9) =  trim(p_org_information9) ;

Line: 472


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
	AND 	ou.organization_id = hoi.organization_id
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2 ;

Line: 595


				select EFFECTIVE_DATE into l_session_date from fnd_sessions where SESSION_ID = userenv('SESSIONID');

Line: 1080


 PROCEDURE validate_update_org_inf
  (p_effective_date             IN	DATE
  ,p_org_info_type_code		IN	VARCHAR2
  ,p_org_information_id		IN 	NUMBER
  ,p_org_information1		IN	VARCHAR2 DEFAULT null
  ,p_org_information2		IN	VARCHAR2 DEFAULT null
  ,p_org_information3		IN	VARCHAR2 DEFAULT null
  ,p_org_information4		IN	VARCHAR2 DEFAULT null
  ,p_org_information5		IN	VARCHAR2 DEFAULT null
  ,p_org_information6		IN	VARCHAR2 DEFAULT null
  ,p_org_information7		IN	VARCHAR2 DEFAULT null
  ,p_org_information8		IN	VARCHAR2 DEFAULT null
  ,p_org_information9		IN	VARCHAR2 DEFAULT null
  ) IS

	l_length					NUMBER ;

Line: 1136


	SELECT	business_group_id
	FROM	hr_organization_units
	where	organization_id = l_organization_id;

Line: 1142


	SELECT	organization_id
	FROM 	hr_organization_information
	WHERE 	org_information_id = p_org_information_id;

Line: 1148


	SELECT 	COUNT(*)
	FROM 	hr_organization_units o , hr_organization_information hoi  ,fnd_sessions s
	WHERE 	o.organization_id = hoi.organization_id
	AND 	hoi.org_information_context = 'CLASS'
	AND 	hoi.org_information1 = 'FI_LOCAL_UNIT'
	AND	o.business_group_id = l_business_group_id
	AND 	TO_CHAR(o.organization_id) IN
				(
				SELECT	hoinf.org_information1
				FROM	hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s
				WHERE	org.business_group_id = l_business_group_id
				AND	org.organization_id = hoinf.organization_id
				AND	org.organization_id <> l_organization_id
				AND	hoinf.org_information_context = 'FI_LOCAL_UNITS'
				AND 	s.session_id = userenv('sessionid')
				AND 	s.effective_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
				)
	AND	s.session_id = userenv('sessionid')
	AND	s.effective_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))
	AND	o.organization_id = p_org_information1;

Line: 1171


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
		 hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id <> nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1  = p_org_information1 ;

Line: 1181


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_TYPES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1192


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_TYPES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information_id <> p_org_information_id
	AND        hoi.org_information2 IS NULL
	AND        hoi.org_information3 IS NULL;

Line: 1204


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information3 =  p_org_information3
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1215


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
	AND 	ou.organization_id = hoi.organization_id
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1225


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_PROVIDERS')
	AND	ou.business_group_id = l_business_group_id
	AND 	ou.organization_id = hoi.organization_id
	AND	hoi.org_information6 =  p_org_information6
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1234


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_PROVIDERS')
	AND	ou.business_group_id = l_business_group_id
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	trim(hoi.org_information9) =  trim(p_org_information9)
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1245


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1256


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	 (( fnd_date.canonical_to_date(p_org_information1) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( fnd_date.canonical_to_date(hoi.org_information1) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1273


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	 (( fnd_date.canonical_to_date(p_org_information1) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(hoi.org_information1) AND
	nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( fnd_date.canonical_to_date(hoi.org_information1) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY')))
	OR  ( nvl(fnd_date.canonical_to_date(hoi.org_information2),to_date('31/12/4712','DD/MM/YYYY')) between  fnd_date.canonical_to_date(p_org_information1) AND
	nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))))
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1293


	SELECT 	COUNT(*)
	FROM 	hr_organization_information hoi, hr_organization_units ou
	WHERE 	(hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
	AND 	ou.organization_id = hoi.organization_id
	AND 	ou.organization_id = nvl(l_organization_id , 0)
	AND	ou.business_group_id = l_business_group_id
	AND	hoi.org_information1 =  p_org_information1
	AND	hoi.org_information2 =  p_org_information2
	AND	hoi.org_information_id <> p_org_information_id	;

Line: 1324


			fnd_message.set_name('PER', 'Update');

Line: 1426


				SELECT  EFFECTIVE_DATE INTO  l_session_date FROM  fnd_sessions WHERE  SESSION_ID = userenv('SESSIONID');

Line: 1911


 END validate_update_org_inf;

Line: 1933


	SELECT	business_group_id
	FROM	hr_organization_units
	WHERE	organization_id = p_organization_id;

Line: 1939


		SELECT hsc.segment12
		FROM HR_ORGANIZATION_UNITS o1
		,HR_ORGANIZATION_INFORMATION hoi1
		,HR_ORGANIZATION_INFORMATION hoi2
		,PER_ALL_ASSIGNMENTS_F paa
		,HR_SOFT_CODING_KEYFLEX hsc
		WHERE o1.business_group_id =l_business_group_id
		and o1.organization_id = hoi1.organization_id
		and hoi1.org_information_context = 'CLASS'
		and hoi1.org_information1 = 'FI_LOCAL_UNIT'
		AND nvl(hoi2.organization_id,-999) =  p_le
		and hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		and o1.organization_id = hoi2.org_information1
		and paa.person_id =p_person_id
		AND    p_effective_date  BETWEEN paa.effective_start_date AND paa.effective_end_date
		and paa.SOFT_CODING_KEYFLEX_ID=hsc.SOFT_CODING_KEYFLEX_ID
		and o1.organization_id = hsc.segment2;

Line: 1959


		SELECT hoi3.organization_id
		FROM HR_ORGANIZATION_UNITS o1
		, HR_ORGANIZATION_INFORMATION hoi1
		, HR_ORGANIZATION_INFORMATION hoi2
		, HR_ORGANIZATION_INFORMATION hoi3
		WHERE  o1.business_group_id =l_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = p_organization_id
		AND hoi1.org_information1 = 'FI_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.ORG_INFORMATION_CONTEXT='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER';

Line: 2019


PROCEDURE  UPDATE_ASG_VALIDATE
(
 p_segment2			IN	VARCHAR2
,p_segment12			IN	VARCHAR2
,p_effective_date		IN	DATE
,p_assignment_id		IN	NUMBER)
IS

	l_person_id		NUMBER;

Line: 2036


	SELECT	business_group_id
	FROM	per_all_assignments_f
	where	assignment_id = p_assignment_id;

Line: 2043


		SELECT hsc.segment12
		FROM HR_ORGANIZATION_UNITS o1
		,HR_ORGANIZATION_INFORMATION hoi1
		,HR_ORGANIZATION_INFORMATION hoi2
		,PER_ALL_ASSIGNMENTS_F paa
		,HR_SOFT_CODING_KEYFLEX hsc
		WHERE o1.business_group_id =l_business_group_id
		and o1.organization_id = hoi1.organization_id
		and hoi1.org_information_context = 'CLASS'
		and hoi1.org_information1 = 'FI_LOCAL_UNIT'
		AND nvl(hoi2.organization_id,-999) =  p_le
		and hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		and o1.organization_id = hoi2.org_information1
		and paa.person_id =l_person_id
		and paa.assignment_id <>  p_assignment_id
		AND     p_effective_date  BETWEEN paa.effective_start_date AND paa.effective_end_date
		and paa.SOFT_CODING_KEYFLEX_ID=hsc.SOFT_CODING_KEYFLEX_ID
		and o1.organization_id = hsc.segment2;

Line: 2064


		SELECT hoi3.organization_id
		FROM HR_ORGANIZATION_UNITS o1
		, HR_ORGANIZATION_INFORMATION hoi1
		, HR_ORGANIZATION_INFORMATION hoi2
		, HR_ORGANIZATION_INFORMATION hoi3
		WHERE  o1.business_group_id =l_business_group_id
		AND hoi1.organization_id = o1.organization_id
		AND hoi1.organization_id = p_segment2
		AND hoi1.org_information1 = 'FI_LOCAL_UNIT'
		AND hoi1.org_information_context = 'CLASS'
		AND o1.organization_id = hoi2.org_information1
		AND hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		AND hoi2.organization_id =  hoi3.organization_id
		AND hoi3.ORG_INFORMATION_CONTEXT='CLASS'
		AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER';

Line: 2084


	SELECT	person_id
	FROM	per_all_assignments_f a
	WHERE	a.assignment_id = p_assignment_id
	AND    p_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;

Line: 2132


END UPDATE_ASG_VALIDATE ;

Line: 2137


 PROCEDURE  UPDATE_TERMINATION_VALIDATE
  (p_leaving_reason                 IN	    VARCHAR2
  )IS
BEGIN
   --
   -- Added for GSI Bug 5472781
   --
   IF hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
     --
     IF p_leaving_reason IS NULL THEN
        fnd_message.set_name('PER', 'HR_376603_FI_MANDATORY_MSG');

Line: 2152


END UPDATE_TERMINATION_VALIDATE ;

Line: 2175


	SELECT	INTERNAL_EXTERNAL_FLAG
	FROM	HR_ORGANIZATION_UNITS
	WHERE	ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 2292


  select min(effective_start_date)
  from per_all_people_f
  where person_id=p_person_id;

Line: 2319


  PROCEDURE PERSON_ABSENCE_UPDATE
  (
   p_absence_attendance_id        IN Number
  ,p_abs_information_category     IN varchar2
  ,p_date_start                   IN Date
  ,p_date_end                     IN Date
  ,p_abs_information1             IN Varchar2 default NULL
  ,p_abs_information2             IN Varchar2 default NULL
  ,p_abs_information3             IN Varchar2 default NULL
  ,p_abs_information4             IN Varchar2 default NULL
  ,p_abs_information5             IN Varchar2 default NULL
  ) IS

  cursor get_start_date(l_person_id number) is
  select min(effective_start_date)
  from per_all_people_f
  where person_id=l_person_id;

Line: 2338


	select person_id
        from   per_absence_attendances
        where  absence_attendance_id =p_absence_attendance_id;

Line: 2369


  END PERSON_ABSENCE_UPDATE;