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.PER_PL_ORG_INFO SQL Statements

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

Line: 72


    Cursor cur_nip is select org_information3 from hr_organization_information where org_information_context = 'PL_TAX_INFO'
                and org_information_id <> nvl(p_org_information_id,0) and org_information3 = p_org_information3;

Line: 132


   select 1
          from hr_organization_information where
               organization_id = ORG_ID and
	       org_information_context = ORG_INFO_TYPE_CODE and
	       (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(ORG_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(ORG_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
                fnd_date.canonical_to_date(ORG_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(ORG_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: 148


   select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from
hr_organization_units where organization_id = ORG_ID;

Line: 195


PROCEDURE UPDATE_ORG_DETAILS(p_org_id             number,
                             P_ORG_INFORMATION_ID number,
                             P_FLEX_START_DATE    VARCHAR2,
                             P_FLEX_END_DATE      VARCHAR2,
                             P_ORG_INFO_TYPE_CODE VARCHAR2) IS


cursor csr_overlap_upd_rec is
   select 1
          from hr_organization_information where
               organization_id = p_org_id and
	       org_information_context = P_ORG_INFO_TYPE_CODE and
	       (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(ORG_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(ORG_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(ORG_INFORMATION1)
                                 and  nvl(fnd_date.canonical_to_date(ORG_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
                fnd_date.canonical_to_date(ORG_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(ORG_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')))
               and org_information_id <> P_ORG_INFORMATION_ID;

Line: 220


   select date_from, nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) from
   hr_organization_units where organization_id = p_org_id;

Line: 260


END UPDATE_ORG_DETAILS;

Line: 375


PROCEDURE UPDATE_PL_ORG_INFO(P_EFFECTIVE_DATE  DATE
					,P_ORG_INFO_TYPE_CODE VARCHAR2
					,P_ORG_INFORMATION1 VARCHAR2
					,P_ORG_INFORMATION2 VARCHAR2
					,P_ORG_INFORMATION3 VARCHAR2
					,P_ORG_INFORMATION4 VARCHAR2
					,P_ORG_INFORMATION5 VARCHAR2
					,P_ORG_INFORMATION6 VARCHAR2
					,P_ORG_INFORMATION7 VARCHAR2
					,P_ORG_INFORMATION8 VARCHAR2
					,P_ORG_INFORMATION9 VARCHAR2
					,P_ORG_INFORMATION10 VARCHAR2
					,P_ORG_INFORMATION11 VARCHAR2
					,P_ORG_INFORMATION12 VARCHAR2
					,P_ORG_INFORMATION13 VARCHAR2
					,P_ORG_INFORMATION14 VARCHAR2
					,P_ORG_INFORMATION15 VARCHAR2
					,P_ORG_INFORMATION16 VARCHAR2
					,P_ORG_INFORMATION17 VARCHAR2
					,P_ORG_INFORMATION18 VARCHAR2
					,P_ORG_INFORMATION19 VARCHAR2
					,P_ORG_INFORMATION20 VARCHAR2
					,P_ORG_INFORMATION_ID NUMBER
                            ) IS

cursor csr_org_id is
     select organization_id from hr_organization_information where
org_information_id = P_ORG_INFORMATION_ID;

Line: 410


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

Line: 429


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 436


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 443


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 451


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 458


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 467


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 475


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 485


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 493


      UPDATE_ORG_DETAILS(p_org_id,
                         P_ORG_INFORMATION_ID,
                         P_ORG_INFORMATION1,
                         P_ORG_INFORMATION2,
                         P_ORG_INFO_TYPE_CODE);

Line: 505


END UPDATE_PL_ORG_INFO;