APPS.PAY_PAP_BUS SQL Statements

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

Line: 36

  SELECT pbg.legislation_code
  FROM   per_business_groups pbg
  WHERE  pbg.business_group_id = p_business_group_id;

Line: 46

  SELECT ff.formula_name
  FROM   ff_formulas_f ff
        ,ff_formula_types ft
  WHERE  ff.formula_id = p_formula_id
  AND    ff.formula_type_id = ft.formula_type_id
  AND    ft.formula_type_name = p_formula_type_name
  AND    p_effective_date BETWEEN
         ff.effective_start_date and ff.effective_end_date
  AND   (ff.business_group_id IS NULL OR
         (ff.business_group_id IS NOT NULL AND
          ff.business_group_id = p_business_group_id))
  AND   (ff.legislation_code IS NULL OR
         (ff.legislation_code IS NOT NULL AND
          ff.legislation_code = l_legislation_code));

Line: 108

  SELECT 'Y'
  FROM   pay_accrual_plans pap
  WHERE  UPPER(pap.accrual_plan_name) = UPPER(p_accrual_plan_name)
  AND    pap.business_group_id = p_business_group_id
  AND  ((p_accrual_plan_id is null)
   OR   (p_accrual_plan_id is not null and
         pap.accrual_plan_id <> p_accrual_plan_id));

Line: 560

  SELECT pet.element_type_id
  FROM   pay_element_types_f pet
        ,pay_input_values_f piv
  WHERE  piv.input_value_id = p_pto_input_value_id
  AND    (piv.business_group_id = p_business_group_id
       OR (piv.business_group_id is null
           AND piv.legislation_code = l_legislation_code))
  AND    piv.element_type_id = pet.element_type_id
  AND  ((piv.uom = 'ND' AND
         p_accrual_units_of_measure = 'D')
   OR   ((piv.uom like 'H_DECIMAL_%' OR
          piv.uom like 'H_HH%') AND
         p_accrual_units_of_measure = 'H'));

Line: 579

  SELECT null
  FROM   pay_element_types_f pet
        ,pay_element_classifications pec
  WHERE  pet.element_type_id = l_element_type_id
  AND    pet.classification_id = pec.classification_id
  AND   (pet.processing_type = 'N'
   OR    (pet.processing_type = 'R' AND pet.proration_group_id IS NOT NULL))
  AND    (pet.business_group_id = p_business_group_id
        OR (pet.business_group_id is null
          AND pet.legislation_code = l_legislation_code))
  AND  ((upper(pec.classification_name) = 'INFORMATION' AND
         pet.element_information1 = 'ABS' AND
         p_accrual_units_of_measure = 'H')
   OR   (EXISTS (SELECT null
                 FROM   per_absence_attendance_types paat
                 WHERE  paat.input_value_id IS NOT NULL
                 AND    paat.input_value_id = p_pto_input_value_id
                 AND    paat.business_group_id = p_business_group_id
                 AND  ((paat.hours_or_days = 'D' AND
                        p_accrual_units_of_measure = 'D')
                  OR   (paat.hours_or_days = 'H' AND
                        p_accrual_units_of_measure = 'H')))));

Line: 604

  SELECT pbg.legislation_code
  FROM   per_business_groups pbg
  WHERE  pbg.business_group_id = p_business_group_id;

Line: 716

  SELECT pbd.dimension_name
  FROM   pay_balance_dimensions pbd
        ,pay_defined_balances pdb
  WHERE  pdb.defined_balance_id = p_defined_balance_id
  AND    pdb.balance_dimension_id = pbd.balance_dimension_id;

Line: 726

  SELECT hoi.org_information1
  FROM   hr_organization_information hoi
  WHERE  hoi.organization_id = p_business_group_id
  AND    hoi.org_information_context = 'PTO Balance Type';

Line: 735

  SELECT plr.rule_mode
  FROM   pay_legislation_rules plr
  WHERE  plr.rule_type = 'PTO_BALANCE_TYPE'
  AND    plr.legislation_code =
           (SELECT pbg.legislation_code
            FROM   per_business_groups pbg
            WHERE  pbg.business_group_id = p_business_group_id);

Line: 781

      fnd_message.set_name('PER','HR_289823_PAP_BAL_DIM_UPDATE');

Line: 1279

  cursor csr_leg_code is select legislation_code
                         from per_business_Groups
                         where business_group_id = p_business_Group_id;

Line: 1339

PROCEDURE insert_validate
  (p_effective_date   IN  DATE
  ,p_rec              IN  pay_pap_shd.g_rec_type
  ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
IS

  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1489

END insert_validate;

Line: 1494

PROCEDURE update_validate
  (p_effective_date   IN  DATE
  ,p_rec              IN  pay_pap_shd.g_rec_type
  ,p_check_accrual_ff OUT NOCOPY BOOLEAN)
IS

  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1626

END update_validate;

Line: 1631

Procedure delete_validate(p_rec in pay_pap_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1641

End delete_validate;

Line: 1654

    select a.legislation_code
    from   per_business_groups a,
           pay_accrual_plans b
    where b.accrual_plan_id      = p_accrual_plan_id
    and   a.business_group_id = b.business_group_id;

Line: 1710

    select pbg.security_group_id
      from per_business_groups  pbg
         , pay_accrual_plans    pap
     where pap.accrual_plan_id   = p_accrual_plan_id
       and pbg.business_group_id = pap.business_group_id
  order by pap.accrual_plan_name;