APPS.PEPTOEXC SQL Statements

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

Line: 177

  select add_months(pps.date_start,
                    12 + trunc(months_between(bact.effective_date,
                                              pps.date_start
                                              )/12) *12) finyear
  into l_accrual_year_end
  from per_periods_of_service pps,
       per_all_assignments_f asg,
       pay_payroll_actions bact,
       pay_assignment_actions bal_assact
  where bact.payroll_action_id = p_owner_payroll_action_id
  and   bal_assact.payroll_action_id = bact.payroll_action_id
  and   pps.period_of_service_id = asg.period_of_service_id
  and   asg.assignment_id = bal_assact.assignment_id
  and   bal_assact.assignment_action_id = p_owner_assignment_action_id
  and   bact.effective_date between asg.effective_start_date
                                and asg.effective_end_date;

Line: 224

  select add_months(pps.date_start,
                    12 + trunc(months_between(bact.effective_date,
                                              pps.date_start
                                              )/12) *12) finyear
  into l_accrual_year_end
  from per_periods_of_service pps,
       per_all_assignments_f asg,
       pay_payroll_actions bact,
       pay_assignment_actions bal_assact
  where bact.payroll_action_id = p_owner_payroll_action_id
  and   bal_assact.payroll_action_id = bact.payroll_action_id
  and   pps.period_of_service_id = asg.period_of_service_id
  and   asg.assignment_id = bal_assact.assignment_id
  and   bal_assact.assignment_action_id = p_owner_assignment_action_id
  and   bact.effective_date between asg.effective_start_date
                                and asg.effective_end_date;

Line: 277

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 335

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 378

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 449

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 501

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 521

  select add_months(pps.date_start,
                    12 + trunc(months_between(bact.date_earned,
                                              pps.date_start
                                              )/12) *12) finyear
  into l_expiry_date
  from per_periods_of_service pps,
       per_all_assignments_f asg,
       pay_payroll_actions bact,
       pay_assignment_actions bal_assact
  where bact.payroll_action_id = p_owner_payroll_action_id
  and   bal_assact.payroll_action_id = bact.payroll_action_id
  and   pps.period_of_service_id = asg.period_of_service_id
  and   asg.assignment_id = bal_assact.assignment_id
  and   bal_assact.assignment_action_id = p_owner_assignment_action_id
  and   bact.date_earned between asg.effective_start_date
                             and asg.effective_end_date;

Line: 579

  select date_earned
  from pay_payroll_actions
  where payroll_action_id = p_payroll_action_id;

Line: 587

  select add_months(pps.date_start,
                    12 + trunc(months_between(bact.date_earned,
                                              pps.date_start
                                              )/12) *12) finyear
  into l_expiry_date
  from per_periods_of_service pps,
       per_all_assignments_f asg,
       pay_payroll_actions bact,
       pay_assignment_actions bal_assact
  where bact.payroll_action_id = p_owner_payroll_action_id
  and   bal_assact.payroll_action_id = bact.payroll_action_id
  and   pps.period_of_service_id = asg.period_of_service_id
  and   asg.assignment_id = bal_assact.assignment_id
  and   bal_assact.assignment_action_id = p_owner_assignment_action_id
  and   bact.date_earned between asg.effective_start_date
                             and asg.effective_end_date;