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_AEI_INFO SQL Statements

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

Line: 8


select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=R_ASSIGNMENT_ID;

Line: 34


   select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
    from   per_assignment_extra_info
    where  information_type='PL_PAYMENT_CONDITIONS'
    and    ASSIGNMENT_ID=p_assignment_id
    and    aei_information_category='PL_PAYMENT_CONDITIONS'
    and    AEI_INFORMATION3=p_AEI_INFORMATION3
    and   (
          l_date_from between fnd_date.canonical_to_date(aei_information1)
                      and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
          or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
                                          and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
          or fnd_date.canonical_to_date(aei_information1)
                                        between l_date_from
                              and nvl(l_date_to,l_end_of_time)
           );

Line: 103


procedure UPDATE_PL_PAYMENT_CONDITIONS(

 P_ASSIGNMENT_EXTRA_INFO_ID   in   NUMBER,
 P_AEI_INFORMATION1           in   varchar2 ,
 P_AEI_INFORMATION2           in   varchar2 ,
 P_AEI_INFORMATION3           in   varchar2 ,
 P_AEI_INFORMATION4           in   varchar2 ,
 P_AEI_INFORMATION5           in   varchar2 ,
 P_AEI_INFORMATION6           in   varchar2 ,
 P_AEI_INFORMATION7           in   varchar2
 )
 as

l_end_of_time               date;

Line: 125


 select assignment_id
 from  per_assignment_extra_info
 where information_type='PL_PAYMENT_CONDITIONS'
 and   ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;

Line: 131


 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
 from   per_assignment_extra_info
 where  information_type='PL_PAYMENT_CONDITIONS'
 and    per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
 and    aei_information_category='PL_PAYMENT_CONDITIONS'
 and    AEI_INFORMATION3=p_AEI_INFORMATION3
 and    ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
 and  (
      l_date_from                    between fnd_date.canonical_to_date(aei_information1)
                                         and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
    or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
                                         and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
    or fnd_date.canonical_to_date(aei_information1)
                                     between l_date_from
                                         and nvl(l_date_to ,l_end_of_time)
       );

Line: 151


  l_proc:= g_package||'UPDATE_PL_PAYMENT_CONITIONS';

Line: 207


END UPDATE_PL_PAYMENT_CONDITIONS; --end procedure

Line: 227


   select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
    from   per_assignment_extra_info
    where  information_type='PL_OTHER_WORK_CONDITIONS'
    and    ASSIGNMENT_ID=p_assignment_id
    and    aei_information_category=p_aei_information_category
    and    AEI_INFORMATION3=p_AEI_INFORMATION3
    and   (
          fnd_date.canonical_to_date(p_aei_information1)
                          between fnd_date.canonical_to_date(aei_information1)
                              and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
          or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
                          between fnd_date.canonical_to_date(aei_information1)
                              and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
          or fnd_date.canonical_to_date(  aei_information1)
                          between fnd_date.canonical_to_date(p_aei_information1)
                              and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
          or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
                          between fnd_date.canonical_to_date(p_aei_information1)
                              and fnd_date.canonical_to_date(p_aei_information2)
           );

Line: 345


 procedure UPDATE_PL_ASSGT_EXTRA_INFO(

 P_ASSIGNMENT_EXTRA_INFO_ID   in   NUMBER,
 p_aei_information_category   in   VARCHAR2,
 P_AEI_INFORMATION1           in   varchar2 ,
 P_AEI_INFORMATION2           in   varchar2 ,
 P_AEI_INFORMATION3           in   varchar2 ,
 P_AEI_INFORMATION4           in   varchar2 ,
 P_AEI_INFORMATION5           in   varchar2 ,
 P_AEI_INFORMATION6           in   varchar2 ,
 P_AEI_INFORMATION7           in   varchar2
 )
 as


 cursor csr_assignment_id is
 select assignment_id
 from  per_assignment_extra_info
 where information_type='PL_OTHER_WORK_CONDITIONS'
 and   ASSIGNMENT_EXTRA_INFO_ID=P_ASSIGNMENT_EXTRA_INFO_ID;

Line: 367


 select AEI_INFORMATION1,AEI_INFORMATION2,AEI_INFORMATION3
 from   per_assignment_extra_info
 where  information_type='PL_OTHER_WORK_CONDITIONS'
 and    per_assignment_extra_info.ASSIGNMENT_ID=r_assignment_id
 and    aei_information_category=p_aei_information_category
 and    AEI_INFORMATION3=p_AEI_INFORMATION3
 and    ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
 and  (
      fnd_date.canonical_to_date(p_aei_information1)
                                 between fnd_date.canonical_to_date(aei_information1)
                                     and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
    or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
                                 between fnd_date.canonical_to_date(aei_information1)
                                     and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
    or fnd_date.canonical_to_date(aei_information1)
                                 between fnd_date.canonical_to_date(p_aei_information1)
                                     and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
    or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
                                 between fnd_date.canonical_to_date(p_aei_information1)
                                     and fnd_date.canonical_to_date(p_aei_information2)
       );

Line: 402


  l_proc:=  'UPDATE_PL_ASSGT_EXTRA_INFO';

Line: 459


    UPDATE_PL_PAYMENT_CONDITIONS(   P_ASSIGNMENT_EXTRA_INFO_ID  => P_ASSIGNMENT_EXTRA_INFO_ID,
                                    P_AEI_INFORMATION1          => P_AEI_INFORMATION1,
                                    P_AEI_INFORMATION2          => P_AEI_INFORMATION2,
                                    P_AEI_INFORMATION3          => P_AEI_INFORMATION3,
                                    P_AEI_INFORMATION4          => P_AEI_INFORMATION4,
                                    P_AEI_INFORMATION5          => P_AEI_INFORMATION5,
                                    P_AEI_INFORMATION6          => P_AEI_INFORMATION6,
                                    P_AEI_INFORMATION7          => P_AEI_INFORMATION7);

Line: 476


END UPDATE_PL_ASSGT_EXTRA_INFO; --end procedure update