APPS.PQP_LOG_ALIEN_DATA_CHANGES SQL Statements

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

Line: 83

   SELECT pet.element_type_id,
          pet.element_information1 inc_code             ---'x'
   FROM   pay_element_types_f  PET,
          pay_element_links_f  PEL
   WHERE  PEL.element_link_id = p_element_link_id
     AND  PEL.element_type_id = PET.element_type_id
     AND  p_effective_date BETWEEN PET.effective_start_date AND
                                   PET.effective_end_date
     AND  p_effective_date BETWEEN PEL.effective_start_date AND
                                   PEL.effective_end_date
     AND  EXISTS (SELECT 'x'
                  FROM   pay_element_classifications PEC
                  WHERE  PEC.classification_id   = PET.classification_id
                    AND  PEC.classification_name = 'Alien/Expat Earnings'
                    AND  PEC.legislation_code    = 'US' );

Line: 102

    SELECT 'X'
      FROM pqp_analyzed_alien_details paad
          ,pqp_analyzed_alien_data pad
    where  pad.analyzed_data_id=paad.analyzed_data_id
      and pad.tax_year=to_number(to_char(cp_effective_date,'YYYY'))
      and pad.assignment_id=cp_assignment_id
      and pad.data_source='PQP_US_ALIEN_WINDSTAR'
      AND paad.income_code=cp_inc_code;

Line: 199

   SELECT effective_date
   FROM   fnd_sessions
   WHERE  session_id = userenv('sessionid');

Line: 204

   SELECT assignment_id
   FROM   per_assignments_f
   WHERE  person_id           = p_person_id
   --AND  effective_end_date >= NVL(l_session_date, sysdate);

Line: 356

   SELECT 'x'
   FROM   pay_process_events
   WHERE  assignment_id = p_assignment_id
     AND  change_type   = 'PQP_US_ALIEN_WINDSTAR'
     AND  status in ('N', 'D'); -- NOT_READ, DATA_VALIDATION_FAILED

Line: 401

PROCEDURE log_pei_insert_changes (p_person_id          in number
                                 ,p_information_type   in varchar2
                                 ,p_pei_information5   in varchar2
                                 ,p_pei_information6   in varchar2
                                 ,p_pei_information7   in varchar2
                                 ,p_pei_information8   in varchar2
                                 ,p_pei_information9   in varchar2
                                 ,p_pei_information10  in varchar2
                                 ,p_pei_information11  in varchar2
                                 ,p_pei_information12  in varchar2
                                 ,p_pei_information13  in varchar2 ) IS
   --
   -- Procedure which will be called by the PER_PEOPLE_EXTRA_INFO API USER
   -- HOOKS to check whether the event is already logged.
   -- Legislative user hook is used due to mutating table problem for
   -- dynamic triggers on this table.
   --
   l_proc  VARCHAR2(60) := 'pqp_log_alien_data_changes.log_pei_insert_changes';

Line: 450

END log_pei_insert_changes;

Line: 454

PROCEDURE log_pei_update_changes
                   (p_person_id           in number
                   ,p_information_type    in varchar2
                   ,p_information_type_o  in varchar2
                   ,p_pei_information5    in varchar2
                   ,p_pei_information5_o  in varchar2
                   ,p_pei_information6    in varchar2
                   ,p_pei_information6_o  in varchar2
                   ,p_pei_information7    in varchar2
                   ,p_pei_information7_o  in varchar2
                   ,p_pei_information8    in varchar2
                   ,p_pei_information8_o  in varchar2
                   ,p_pei_information9    in varchar2
                   ,p_pei_information9_o  in varchar2
                   ,p_pei_information10   in varchar2
                   ,p_pei_information10_o in varchar2
                   ,p_pei_information11   in varchar2
                   ,p_pei_information11_o in varchar2
                   ,p_pei_information12   in varchar2
                   ,p_pei_information12_o in varchar2
                   ,p_pei_information13   in varchar2
                   ,p_pei_information13_o in varchar2 ) IS
   --
   l_proc  VARCHAR2(60) := 'pqp_log_alien_data_changes.log_pei_update_changes';

Line: 509

END log_pei_update_changes;