APPS.PAY_PYNZSOE_XMLP_PKG SQL Statements

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

Line: 18

  select payroll_name
  into l_param_display_payroll_name
  from pay_payrolls_f
  where payroll_id = P_Payroll_Id;

Line: 27

  select fcl.meaning
  into l_param_display_payroll_action
  from pay_payroll_actions ppa,
       hr_lookups fcl
  where fcl.lookup_type = 'ACTION_TYPE'
  and ppa.payroll_action_id = P_Payroll_Action_Id
  and ppa.action_type = fcl.lookup_code;

Line: 172

            select substr(ppos.name,1,30)
       into l_position_name
       from per_assignments_f paf,
            per_positions ppos
       where paf.position_id = ppos.position_id
       --and paf.assignment_id = assignment_id
       and paf.assignment_id = v_assignment_id
       and date_earned between paf.effective_start_date and paf.effective_end_date;