APPS.PYZAEXC SQL Statements

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

Line: 66

      select
         date_earned, payroll_id
      into
         l_owner_date_earned, l_owner_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_owner_payroll_action_id;

Line: 76

      select
         date_earned, payroll_id
      into
         l_user_date_earned, l_user_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_user_payroll_action_id;

Line: 86

      select
         prd_information1
      into
         l_owner_tax_year
      from
         per_time_periods
      where
         payroll_id = l_owner_payroll_id
      and
         l_owner_date_earned between start_date and end_date;

Line: 98

      select
         prd_information1
      into
         l_user_tax_year
      from
         per_time_periods
      where
         payroll_id = l_user_payroll_id
      and
         l_user_date_earned between start_date and end_date;

Line: 170

 select rule_mode
 into l_tax_start_day
 from pay_legislation_rules
 where legislation_code = 'ZA'
 and rule_type = 'L';

Line: 178

select to_char(p_owner_effective_date,'YYYY')
into l_tax_year
from dual;

Line: 184

SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
INTO l_tax_year_start_date
FROM dual;

Line: 189

SELECT (add_months(l_tax_year_start_date,
        (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
INTO p_expiry_information
from dual;

Line: 239

      select
         date_earned, payroll_id
      into
         l_owner_date_earned, l_owner_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_owner_payroll_action_id;

Line: 249

      select
         date_earned, payroll_id
      into
         l_user_date_earned, l_user_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_user_payroll_action_id;

Line: 259

      select
         prd_information3
      into
         l_owner_cal_year
      from
         per_time_periods
      where
         payroll_id = l_owner_payroll_id
      and
         l_owner_date_earned between start_date and end_date;

Line: 271

      select
         prd_information3
      into
         l_user_cal_year
      from
         per_time_periods
      where
         payroll_id = l_user_payroll_id
      and
         l_user_date_earned between start_date and end_date;

Line: 329

SELECT (trunc(add_months(p_owner_effective_date,12),'Y')-1)
INTO p_expiry_information
from dual;

Line: 377

      select
         date_earned, payroll_id
      into
         l_owner_date_earned, l_owner_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_owner_payroll_action_id;

Line: 387

      select
         date_earned, payroll_id
      into
         l_user_date_earned, l_user_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_user_payroll_action_id;

Line: 397

      select
         prd_information1, prd_information2
      into
         l_owner_tax_year, l_owner_tax_quarter
      from
         per_time_periods
      where
         payroll_id = l_owner_payroll_id
      and
         l_owner_date_earned between start_date and end_date;

Line: 409

      select
         prd_information1, prd_information2
      into
         l_user_tax_year, l_user_tax_quarter
      from
         per_time_periods
      where
         payroll_id = l_user_payroll_id
      and
         l_user_date_earned between start_date and end_date;

Line: 475

 select rule_mode
 into l_tax_start_day
 from pay_legislation_rules
 where legislation_code = 'ZA'
 and rule_type = 'L';

Line: 481

select to_char(p_owner_effective_date,'YYYY')
into l_tax_year
from dual;

Line: 485

SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
INTO l_tax_year_start_date
FROM dual;

Line: 489

SELECT (add_months(l_tax_year_start_date,
                (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 3) + 1) * 3) -1 )
INTO p_expiry_information
FROM dual;

Line: 537

      select
         date_earned, payroll_id
      into
         l_owner_date_earned, l_owner_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_owner_payroll_action_id;

Line: 547

      select
         date_earned, payroll_id
      into
         l_user_date_earned, l_user_payroll_id
      from
         pay_payroll_actions
      where
         payroll_action_id = p_user_payroll_action_id;

Line: 557

      select
         pay_advice_date
      into
         l_owner_month
      from
         per_time_periods
      where
         payroll_id = l_owner_payroll_id
      and
         l_owner_date_earned between start_date and end_date;

Line: 569

      select
         pay_advice_date
      into
         l_user_month
      from
         per_time_periods
      where
         payroll_id = l_user_payroll_id
      and
         l_user_date_earned between start_date and end_date;

Line: 629

  SELECT ((trunc(add_months(p_owner_effective_date,1),'MM'))-1)
  INTO  p_expiry_information
  FROM dual;

Line: 668

   select
      time_period_id
   into
      l_owner_time_period_id
   from
      pay_payroll_actions
   where
      payroll_action_id = p_owner_payroll_action_id;

Line: 678

   select
      time_period_id
   into
      l_user_time_period_id
   from
      pay_payroll_actions
   where
      payroll_action_id = p_user_payroll_action_id;

Line: 728

   SELECT ptp.end_date
   INTO   p_expiry_information
   FROM   per_time_periods    ptp
         ,pay_payroll_actions ppa
   WHERE  ppa.payroll_action_id = p_owner_payroll_action_id
     AND  ppa.payroll_id        = ptp.payroll_id
     AND  p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;