APPS.PAYRPENP SQL Statements

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

Line: 44

select tax.name
from
hr_soft_coding_keyflex      flx,
hr_organization_units       tax,
hr_organization_information inf
where
tax.organization_id                 = inf.organization_id
and inf.org_information_context||'' = 'CLASS'
and inf.org_information1            = 'HR_LEGAL'
and flx.soft_coding_keyflex_id      = p_soft_coding_keyflex_id
and tax.organization_id             = flx.segment1;

Line: 89

select tax.organization_id
from
hr_soft_coding_keyflex      flx,
hr_organization_units       tax,
hr_organization_information inf
where
tax.organization_id                 = inf.organization_id
and inf.org_information_context||'' = 'CLASS'
and inf.org_information1            = 'HR_LEGAL'
and flx.soft_coding_keyflex_id      = p_soft_coding_keyflex_id
and tax.organization_id             = flx.segment1;

Line: 134

select loc.location_code
from hr_locations loc
where loc.location_id = p_location_id;

Line: 172

select assignment_action_id           -- Bug 3372714: Single query is broken into two queries to reduce the cost.
  from pay_assignment_actions act
 where act.assignment_id = p_assignment_id
   and act.action_status in ('C', 'S')
   and exists
       (select 'x'
          from per_time_periods ptp  ,
               pay_payroll_actions pct
         where ptp.time_period_id      = p_time_period_id
           and ptp.time_period_id      = pct.time_period_id
           and pct.effective_date between ptp.start_date and ptp.end_Date
           and act.payroll_action_id  = pct.payroll_action_id
        );