APPS.PAY_IE_ARCHIVE_DETAIL_PKG SQL Statements

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

Line: 29

   SELECT peev.screen_entry_value,
          pee.updating_action_id
   FROM pay_element_entry_values_f peev,
        pay_element_entries_f    pee,
        pay_assignment_actions   paa
   WHERE  pee.element_entry_id = peev.element_entry_id
   AND    pee.assignment_id    = paa.assignment_id
   AND    paa.assignment_action_id  = p_run_assignment_action_id
   AND    peev.input_value_id +0  = p_input_value_id
   AND    to_date(p_date_earned, 'YYYY/MM/DD')
   BETWEEN
          pee.effective_start_date
      AND pee.effective_end_date
   AND  to_date(p_date_earned, 'YYYY/MM/DD')
   BETWEEN
          peev.effective_start_date
      AND peev.effective_end_date;

Line: 50

     SELECT    result_value
     FROM      pay_run_result_values   prr,
               pay_run_results         pr,
               pay_element_types_f     pet,
               pay_input_values_f      piv
     WHERE     pr.assignment_action_id   =   p_run_assignment_action_id
     and       pr.element_type_id        =   pet.element_type_id
     and       pr.run_result_id          =   prr.run_result_id
     and       prr.input_value_id        =   piv.input_value_id
     and       pet.element_type_id       =   piv.element_type_id
     and       piv.input_value_id        =   p_input_value_id
     and       piv.business_group_id     IS NULL
     and       piv.legislation_code      =  'IE'
     and       to_date(p_date_earned, 'YYYY/MM/DD')
               between piv.effective_start_date
               and piv.effective_end_date
     and       to_date(p_date_earned, 'YYYY/MM/DD')
               between pet.effective_start_date
               and pet.effective_end_date;

Line: 130

SELECT legislative_parameters
FROM   pay_payroll_actions
WHERE  payroll_action_id = p_pact_id;

Line: 176

SELECT SUBSTR(legislative_parameters,
               INSTR(legislative_parameters,p_token)+(LENGTH(p_token)+1),
                INSTR(legislative_parameters,' ',
                       INSTR(legislative_parameters,p_token))
                 - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
       business_group_id
FROM   pay_payroll_actions
WHERE  payroll_action_id = p_pact_id;

Line: 204

     SELECT   count(distinct org_information8) paycount,
              org_information8
     FROM     pay_all_payrolls_f papf
        ,     hr_organization_information org
        ,     hr_soft_coding_keyflex sck
      WHERE
              papf.consolidation_set_id    =  pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
              and  to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
              between papf.effective_start_date and papf.effective_end_date
      and     org.org_information_context  = 'IE_PAYPATH_INFORMATION'
      and     papf.SOFT_CODING_KEYFLEX_ID  =  sck.SOFT_CODING_KEYFLEX_ID
      and     org.ORG_INFORMATION_ID       =  to_number(sck.segment2)
      and     org.org_information8 is not null
      group by org_information8;

Line: 221

      SELECT  org.org_information8
      FROM    hr_organization_information    org
         ,    pay_payroll_actions            ppa
      WHERE
              ppa.payroll_action_id        =  pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
      and     org.organization_id          =  ppa.business_group_id
      and     org.org_information_context  =  'IE_PAYPATH_INFORMATION'
      and     rownum=1;

Line: 232

      SELECT  org.org_information8
      FROM    hr_organization_information org
      WHERE
              org.org_information_context  = 'IE_PAYPATH_INFORMATION'
              and org.ORG_INFORMATION_ID   =
                      (SELECT  to_number(segment2)
                       FROM
			        hr_soft_coding_keyflex sck
		       ,        pay_all_payrolls_f papf
		       ,        pay_payroll_actions ppa
                       WHERE
			        papf.SOFT_CODING_KEYFLEX_ID =  sck.SOFT_CODING_KEYFLEX_ID
		       and      papf.payroll_id             =  pay_magtape_generic.get_parameter_value('PAYROLL_ID')
		       and      papf.consolidation_set_id   =  pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
		       and      ppa.effective_date between papf.effective_start_date and papf.effective_end_date
		       and      ppa.payroll_action_id       =  pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
		       and      papf.payroll_id=ppa.payroll_id);