APPS.PAY_PYR_BUS SQL Statements

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

Line: 232

    SELECT pr.name
	FROM   pay_rates pr
	WHERE  pr.name = p_name
          AND  pr.rate_type = p_rate_type
	  AND  business_group_id = p_business_group_id
	  AND  ((p_rate_id IS NULL) OR
	        (p_rate_id IS NOT NULL AND
			 pr.rate_id <> p_rate_id))
          AND (p_rate_type <> 'A'
               OR
               (p_rate_type = 'A'  AND
                 (   (p_asg_rate_type is not null
                      AND pr.asg_rate_type is not null
                      AND pr.asg_rate_type=p_asg_rate_type)
                  OR (p_asg_rate_type is null
                      AND pr.asg_rate_type is null))
               ));

Line: 334

    SELECT 'X'
	FROM   pay_grade_rules_f pgr
	WHERE  pgr.rate_id = p_rate_id;

Line: 509

    SELECT 'Y'
      FROM per_parent_spines  pps
     WHERE pps.parent_spine_id = p_parent_spine_id;

Line: 597

  SELECT 'y' from dual where exists
  (select 'y'
   from pay_grade_rules_f pgr1
       ,pay_grade_rules_f pgr2
       ,pay_rates pyr1
       ,pay_rates pyr2
   where pgr1.rate_id=pyr1.rate_id
   and   pgr2.rate_id=pyr2.rate_id
   and   pgr1.grade_or_spinal_point_id=pgr2.grade_or_spinal_point_id
   and   pgr1.effective_start_date
         between pgr2.effective_start_date and pgr2.effective_end_date
   and   pgr1.rate_type='A'
   and   pgr2.rate_type='A'
   and   pyr2.asg_rate_type=p_asg_rate_type
   and   pyr1.rate_id=p_rate_id
   and   pyr1.rate_id <> pyr2.rate_id);

Line: 615

  select 'Y' from dual where exists
  (SELECT 'Y'
   FROM fnd_lookups
   WHERE lookup_type='PRICE DIFFERENTIALS'
   AND lookup_code=p_asg_rate_type
   AND enabled_flag='Y'
   AND p_effective_date between nvl(start_date_active,hr_api.g_sot)
                        and nvl(end_date_active,hr_api.g_eot));

Line: 683

    SELECT pbg.security_group_id
      FROM per_business_groups pbg
         , pay_rates pyr
     WHERE pyr.rate_id = p_rate_id
       AND pbg.business_group_id = pyr.business_group_id;

Line: 747

    SELECT pbg.legislation_code
      FROM per_business_groups pbg
         , pay_rates pyr
     WHERE pyr.rate_id = p_rate_id
       AND pbg.business_group_id = pyr.business_group_id;

Line: 972

PROCEDURE chk_non_updateable_args
  (p_effective_date               IN DATE
  ,p_rec IN pay_pyr_shd.g_rec_type
  ) IS
  --
  l_proc     VARCHAR2(72) := g_package || 'chk_non_updateable_args';

Line: 1021

END chk_non_updateable_args;

Line: 1026

PROCEDURE insert_validate
  (p_effective_date               IN DATE
  ,p_rec                          IN pay_pyr_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'insert_validate';

Line: 1117

END insert_validate;

Line: 1122

PROCEDURE update_validate
  (p_effective_date               IN DATE
  ,p_rec                          IN pay_pyr_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'update_validate';

Line: 1150

  chk_non_updateable_args
    (p_effective_date   => p_effective_date
    ,p_rec              => p_rec );

Line: 1222

END update_validate;

Line: 1227

PROCEDURE delete_validate
  (p_rec                          IN pay_pyr_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'delete_validate';

Line: 1241

END delete_validate;