APPS.PER_PL_LEI_INFO SQL Statements

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

Line: 27

   select 1
          from hr_location_extra_info where
               location_id = p_location_id and
	       INFORMATION_TYPE = P_INFORMATION_TYPE and
               (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
	        nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
                    between fnd_date.canonical_to_date(LEI_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
                fnd_date.canonical_to_date(LEI_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
                                nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
                nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
                                 fnd_date.canonical_to_date(P_FLEX_START_DATE) and
                               nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));

Line: 76

PROCEDURE UPDATE_LEI_DETAILS(P_LOCATION_EXTRA_INFO_ID  NUMBER,
                             P_FLEX_START_DATE         VARCHAR2,
                             P_FLEX_END_DATE           VARCHAR2,
                             p_lei_information_category VARCHAR2) IS


cursor csr_overlap_upd_rec is
   select 1
          from hr_location_extra_info where
                      INFORMATION_TYPE = p_lei_information_category
	        and location_extra_info_id <> P_LOCATION_EXTRA_INFO_ID and
                location_id = (select location_id from hr_location_extra_info where LOCATION_EXTRA_INFO_ID = P_LOCATION_EXTRA_INFO_ID)
                and (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
	        nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
                    between fnd_date.canonical_to_date(LEI_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
                fnd_date.canonical_to_date(LEI_INFORMATION1) between fnd_date.canonical_to_date(P_FLEX_START_DATE) and
                                nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
                nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
                                 fnd_date.canonical_to_date(P_FLEX_START_DATE) and
                               nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));

Line: 107

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

Line: 128

END UPDATE_LEI_DETAILS;

Line: 181

PROCEDURE UPDATE_PL_LEI_INFO(p_lei_information_category  VARCHAR2
                             ,p_location_extra_info_id NUMBER
                             ,p_lei_information1  VARCHAR2
                             ,p_lei_information2  VARCHAR2
                             ,p_lei_information3  VARCHAR2
                             ,p_lei_information4  VARCHAR2
                             ,p_lei_information5  VARCHAR2
                             ,p_lei_information6  VARCHAR2
                             ,p_lei_information7  VARCHAR2
                             ,p_lei_information8  VARCHAR2
                             ,p_lei_information9  VARCHAR2
                             ,p_lei_information10 VARCHAR2
                             ,p_lei_information11 VARCHAR2
                             ,p_lei_information12 VARCHAR2
                             ,p_lei_information13 VARCHAR2
                             ,p_lei_information14 VARCHAR2
                             ,p_lei_information15 VARCHAR2
                             ,p_lei_information16 VARCHAR2
                             ,p_lei_information17 VARCHAR2
                             ,p_lei_information18 VARCHAR2
                             ,p_lei_information19 VARCHAR2
                             ,p_lei_information20 VARCHAR2
                             ,p_lei_information21 VARCHAR2
                             ,p_lei_information22 VARCHAR2
                             ,p_lei_information23 VARCHAR2
                             ,p_lei_information24 VARCHAR2
                             ,p_lei_information25 VARCHAR2
                             ,p_lei_information26 VARCHAR2
                             ,p_lei_information27 VARCHAR2
                             ,p_lei_information28 VARCHAR2
                             ,p_lei_information29 VARCHAR2
                             ,p_lei_information30 VARCHAR2
					 ) IS

--
BEGIN
--
	IF p_lei_information_category ='PL_CORRESPONDENCE_ADDRESS' THEN
            UPDATE_LEI_DETAILS(P_LOCATION_EXTRA_INFO_ID,
                               p_lei_information1,
	                       p_lei_information2,
                               p_lei_information_category);

Line: 227

END UPDATE_PL_LEI_INFO;