APPS.PQP_ALIEN_EXPAT_WF_PKG SQL Statements

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

Line: 38

     SELECT assignment_id, description
     FROM  pay_process_events
     WHERE process_event_id = p_process_event_id;

Line: 43

    SELECT ptd.error_indicator, ptd.error_text, ptd.income_code, hrl.meaning
    FROM   pqp_alien_transaction_data ptd, hr_lookups hrl
    WHERE  alien_transaction_id = p_alien_transaction_id
      AND  ptd.income_code      = hrl.lookup_code
      AND  hrl.lookup_type      = 'PQP_US_ALIEN_INCOME_BALANCE';

Line: 50

     SELECT person_id
     FROM  per_all_assignments_f paf
     WHERE assignment_id = l_assignment_id
           and   trunc(p_tran_date) between
                    paf.effective_start_date and
                    paf.effective_end_date;

Line: 58

     SELECT full_name
     FROM  per_all_people_f pap
     WHERE person_id = l_person_id
           and   trunc(p_tran_date) between
                    pap.effective_start_date and
                    pap.effective_end_date;

Line: 67

        select  prl.prl_information1
        from    pay_payrolls_f prl
                ,per_assignments_f paf
        where   prl.payroll_id = paf.payroll_id
                and prl.prl_information_category = 'US'
                and paf.assignment_id = l_assignment_id
                and trunc(p_tran_date) between prl.effective_start_date
                       and  prl.effective_end_date;

Line: 77

        select org.org_information1
        from   hr_organization_information org
        where  org.org_information_context = 'Contact Information'
          and  org.organization_id = (
               select hsc.segment1
               from   per_assignments_f paf
                     ,hr_soft_coding_keyflex hsc
               where  hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
                 and  paf.assignment_id = l_assignment_id
                 and  trunc(p_tran_date) between paf.effective_start_date and
                      paf.effective_end_date);

Line: 93

     select pqp_alntf_wf_item_key_s.nextval
     into   l_item_key
     from   sys.dual;