APPS.PAY_ZA_CALENDARS_PKG SQL Statements

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

Line: 83

   select distinct
      payroll_id, first_period_end_date, period_type
   into
      l_payroll_id, l_fpe, l_period_type
   from
      pay_payrolls_f
   where
      payroll_name = p_payroll_name
   and
      p_effective_date between effective_start_date and effective_end_date;

Line: 95

   select
      min(end_date)
   into
      l_first_end_date
   from
      per_time_periods
   where
      payroll_id = l_payroll_id;

Line: 105

   select
      max(end_date)
   into
      l_last_end_date
   from
      per_time_periods
   where
      payroll_id = l_payroll_id;

Line: 275

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

Line: 339

   select
      fnd_date.canonical_to_date(org_information11)
   into
      l_fiscal_start
   from
      hr_organization_information
   where
      organization_id = p_business_group_id
   and
      org_information_context = 'Business Group Information';

Line: 412

      select
         end_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      order by
         end_date;

Line: 458

            update
               per_time_periods
            set
               pay_advice_date = l_previous_end_date
            where
               payroll_id = p_payroll_id
            and
               end_date between l_store_end_date and l_previous_end_date;

Line: 501

         update
            per_time_periods
         set
            pay_advice_date = l_old_end_date
         where
            payroll_id = p_payroll_id
         and
            end_date between l_end_date and p_last_end_date;

Line: 864

      select
         end_date, pay_advice_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      order by
         end_date;

Line: 877

      select
         end_date, pay_advice_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date < p_first_end_date
      order by
         end_date desc;

Line: 898

      select
         start_date
      into
         l_start_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date = p_first_end_date;

Line: 944

         select
            max(end_date)
         into
            l_store_end_date
         from
            per_time_periods
         where
            payroll_id = p_payroll_id
         and
            pay_advice_date = l_old_pay_me;

Line: 983

                  select
                     max(end_date)
                  into
                     l_store_end_date
                  from
                     per_time_periods
                  where
                     payroll_id = p_payroll_id
                  and
                     pay_advice_date = l_pay_me;

Line: 1007

      update
         per_time_periods
      set
         prd_information1 = to_char(l_tax_year, 'YYYY'),
		 prd_information_category = 'ZA'
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and l_store_end_date;

Line: 1042

            select
               number_per_fiscal_year
            into
               l_no_periods
            from
               per_time_period_types
            where
               period_type = p_proc_period_type;

Line: 1087

               update
                  per_time_periods
               set
                  prd_information1 = to_char(l_tax_year, 'YYYY'),
                  prd_information_category = 'ZA'
               where
                  payroll_id = p_payroll_id
               and
                  end_date between l_old_end_date and p_last_end_date;

Line: 1108

                  update
                     per_time_periods
                  set
                     prd_information1 = to_char(l_tax_year, 'YYYY'),
                     prd_information_category = 'ZA'
                  where
                     payroll_id = p_payroll_id
                  and
                     end_date between l_old_end_date and p_last_end_date;

Line: 1119

                  update
                     per_time_periods
                  set
                     prd_information1 = to_char(l_tax_year, 'YYYY'),
                     prd_information_category = 'ZA'
                  where
                     payroll_id = p_payroll_id
                  and
                     end_date between l_old_end_date and l_store_end_date;

Line: 1199

      select
         end_date, pay_advice_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      order by
         end_date;

Line: 1220

      select
         start_date
      into
         l_start_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date = p_first_end_date;

Line: 1266

         select
            max(end_date)
         into
            l_store_end_date
         from
            per_time_periods
         where
            payroll_id = p_payroll_id
         and
            pay_advice_date = l_old_pay_me;

Line: 1303

                  select
                     max(end_date)
                  into
                     l_store_end_date
                  from
                     per_time_periods
                  where
                     payroll_id = p_payroll_id
                  and
                     pay_advice_date = l_pay_me;

Line: 1327

      update
         per_time_periods
      set
         prd_information3 = to_char(l_cal_year, 'YYYY'),
         prd_information_category = 'ZA'
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and l_store_end_date;

Line: 1362

            select
               number_per_fiscal_year
            into
               l_no_periods
            from
               per_time_period_types
            where
               period_type = p_proc_period_type;

Line: 1404

               update
                  per_time_periods
               set
                  prd_information3 = to_char(l_cal_year, 'YYYY'),
                  prd_information_category = 'ZA'
               where
                  payroll_id = p_payroll_id
               and
                  end_date between l_old_end_date and p_last_end_date;

Line: 1425

                  update
                     per_time_periods
                  set
                     prd_information3 = to_char(l_cal_year, 'YYYY'),
                     prd_information_category = 'ZA'
                  where
                     payroll_id = p_payroll_id
                  and
                     end_date between l_old_end_date and p_last_end_date;

Line: 1436

                  update
                     per_time_periods
                  set
                     prd_information3 = to_char(l_cal_year, 'YYYY'),
                     prd_information_category = 'ZA'
                  where
                     payroll_id = p_payroll_id
                  and
                     end_date between l_old_end_date and l_store_end_date;

Line: 1503

      select
         end_date, pay_advice_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      and
         prd_information1 > c_tax_year
      order by
         end_date;

Line: 1518

      select
         end_date, pay_advice_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         prd_information1 = c_tax_year
      order by
         end_date DESC;

Line: 1534

      select
         prd_information1
      into
         l_tax_year
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date = p_first_end_date;

Line: 1596

               update
                  per_time_periods
               set
                  prd_information2 = to_char(l_quarter),
                  prd_information_category = 'ZA'
               where
                  payroll_id = p_payroll_id
               and
                  end_date between l_end_date and l_old_end_date;

Line: 1623

         update
            per_time_periods
         set
            prd_information2 = to_char(l_quarter),
            prd_information_category = 'ZA'
         where
            payroll_id = p_payroll_id
         and
            end_date between l_end_date and l_old_end_date;

Line: 1678

               update
                  per_time_periods
               set
                  prd_information2 = to_char(l_quarter),
                  prd_information_category = 'ZA'
               where
                  payroll_id = p_payroll_id
               and
                  end_date between l_old_end_date and l_end_date;

Line: 1705

         update
            per_time_periods
         set
            prd_information2 = to_char(l_quarter),
            prd_information_category = 'ZA'
         where
            payroll_id = p_payroll_id
         and
            end_date between l_old_end_date and l_end_date;

Line: 1762

      select distinct
         prd_information1
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      order by
         prd_information1;

Line: 1775

      select
         rowid, end_date
      from
         per_time_periods
      where
         payroll_id = p_payroll_id
      and
         end_date between p_first_end_date and p_last_end_date
      and
         prd_information1 = c_tax_year
      order by
         end_date;

Line: 1800

         select
            period_num
         into
            l_period
         from
            per_time_periods
         where
            payroll_id = p_payroll_id
         and
            end_date = p_first_end_date;

Line: 1830

            update
               per_time_periods
            set
               period_num = l_period
            where
               rowid = l_rowid;

Line: 1838

            update
               per_time_periods
            set
               period_name = to_char(l_period) || ' ' || to_char(l_end_date, 'YYYY')
                             || ' ' || p_proc_period_type
            where
               rowid = l_rowid;