APPS.PYNZEXC SQL Statements

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

Line: 42

  select  ptp.time_period_id
  from    pay_payroll_actions         act
  ,       per_time_periods            ptp
  where   payroll_action_id           = p_payroll_action_id
          and act.date_earned         between ptp.start_date and ptp.end_date
          and act.payroll_id          = ptp.payroll_id
          and act.effective_date      = p_effective_date;

Line: 105

  select  business_group_id
  from    pay_assignment_actions_v
  where   assignment_action_id = p_user_assignment_action_id;

Line: 110

  select  hr_nz_routes.span_start (    bptp.regular_payment_date
                                  ,   p_frequency
                                  ,   p_span_start    )
  from    per_time_periods            bptp
  ,       pay_payroll_actions         bact
  where   bact.payroll_action_id      = p_user_payroll_action_id
          and bact.effective_date     = p_user_effective_date
          and bact.payroll_id         = bptp.payroll_id
          and bact.date_earned        between bptp.start_date and bptp.end_date;

Line: 121

  select  pptp.regular_payment_date
  from    per_time_periods            pptp
  ,       pay_payroll_actions         pact
  where   pact.payroll_action_id      = p_owner_payroll_action_id
          and pact.effective_date     = p_owner_effective_date
          and pact.payroll_id         = pptp.payroll_id
          and pact.date_earned        between pptp.start_date and pptp.end_date;