APPS.PAY_PAYRPANP_XML_PKG SQL Statements

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

Line: 18

    select template_name
    into l_template_name
    from xdo_templates_tl
    where application_short_name= p_app_short_name
    and	template_code= p_template_code
    and	language=userenv('LANG');

Line: 39

 select meaning
 from hr_lookups
 where lookup_type = 'ACTION_TYPE'
 and lookup_code = c_action_type_code ;

Line: 351

select payroll_name
  from pay_payrolls_f
  where payroll_id = c_payroll_id;

Line: 360

select consolidation_set_name
  from pay_consolidation_sets
  where consolidation_set_id = c_consolidation_set_id;

Line: 369

select name
  from per_business_groups
  where business_group_id = c_business_group_id;

Line: 375

   select h.meaning from hr_lookups h
    where h.lookup_type = 'PAY_ACTIONS_NOT_PROCESSED'
      and h.lookup_code = c_mode
      and h.enabled_flag = 'Y';

Line: 425

'select
  ppf.person_id person_id,
  ppf.full_name full_name,
  ppf.employee_number employee_number,
  fnd_date.date_to_displaydate(ppa.effective_date) effective_date,
  ppa.action_type action_type,
  paa.assignment_action_id action_number,
  paf.assignment_number assignment_number,
  pay.payroll_name payroll_name,
  pcs.consolidation_set_name consolidation_set_name

 from
  pay_consolidation_sets pcs,
  pay_all_payrolls_f pay,
  per_all_people_f ppf,
  per_all_assignments_f paf,
  pay_assignment_actions paa,
  pay_payroll_actions ppa

where ' || l_payroll_action_condition ||
  ' and ppa.effective_date between :1 and :2
  and ppa.business_group_id = :3
  and paa.payroll_action_id = ppa.payroll_action_id
  and paf.assignment_id = paa.assignment_id
  and ppf.person_id = paf.person_id
  and ' || l_consolidation_set_condition ||
  ' and ppa.effective_date between paf.effective_start_date
                             and paf.effective_end_date
  and ppa.effective_date between ppf.effective_start_date
                             and ppf.effective_end_date
  and ppa.effective_date between pay.effective_start_date
                             and pay.effective_end_date
  and not exists(
            select null
              from pay_action_interlocks pai,
                   pay_assignment_actions paa_lock,
                   pay_payroll_actions ppa_lock
             where pai.locked_action_id = paa.assignment_action_id
                                          /* Action from main Query */
               and pai.locking_action_id = paa_lock.assignment_action_id
               and ppa_lock.payroll_action_id = paa_lock.payroll_action_id
               and ' ||  l_locking_payroll_condition || ' ) order by ' || l_order_by;