APPS.PAY_PYNZREC_XMLP_PKG SQL Statements

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

Line: 26

  select pap.payroll_name                || ' - ' ||
         ptp.period_name                 || ' ('  ||
         fcl.meaning                     || ' '   ||
         to_char(ppa.display_run_number) || ')'   display
  from   pay_all_payrolls_f  pap,
         per_time_periods    ptp,
         pay_payroll_actions ppa,
         hr_lookups  fcl
  where  ppa.payroll_action_id = c_payroll_action_id
  and    pap.payroll_id        = ppa.payroll_id
  and    ppa.payroll_id        = ptp.payroll_id
  and    ptp.end_date  = ppa.date_earned
  and    fcl.lookup_type       = v_lookup_type
  and    fcl.lookup_code       = ppa.action_type;

Line: 77

  select org_information9
  from   hr_organization_information
  where  organization_id  = c_business_group_id
  and    org_information9 is not null;

Line: 97

    select meaning
    from   hr_lookups
    where  lookup_type = c_lookup_type
    and    lookup_code = c_lookup_code;

Line: 119

  select currency_code
  from   fnd_currencies
  where  issuing_territory_code = c_territory_code;