APPS.PQP_FEDHR_USPAY_INTG_PKG SQL Statements

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

Line: 111

     SELECT fat.application_name application_name
     FROM   fnd_application    fa,
            fnd_application_tl fat
     WHERE  fa.application_id         = fat.application_id
     AND    fa.application_short_name = p_application_short_name
     AND    fat.language              = p_legislation_code;

Line: 168

SELECT name
FROM   per_business_groups_perf
WHERE  business_group_id=p_bg_id;

Line: 1119

       SELECT element_name ele_name
       FROM   pay_element_types_f
       WHERE  element_name=p_ele_name
       AND    business_group_id=p_bg_id;

Line: 1219

SELECT max(display_sequence)   count
FROM   pay_input_values_f
WHERE  element_type_id=p_element_type_id;

Line: 1852

PROCEDURE update_or_ins_pqp_config_vals
(
    errbuf              OUT NOCOPY VARCHAR2,
    retcode             OUT NOCOPY NUMBER,
    p_business_group_id NUMBER,
    p_old_ele_name      VARCHAR2,
    p_new_ele_name      VARCHAR2,
    p_is_PB_Enabled     VARCHAR2,
    p_pay_basis         VARCHAR2
) IS

l_proc                  VARCHAR2(80):='update_or_ins_pqp_config_vals';

Line: 1873

SELECT pcv_information2       ele_type_id,
       configuration_value_id confg_val_id,
       object_version_number  ovn
FROM   pqp_configuration_values
WHERE  pcv_information1                 = p_old_ele_name
       and business_group_id            = p_business_group_id
       and NVL(pcv_information3,'NULL') = NVL(p_pay_basis,'NULL');

Line: 1890

  SELECT element_type_id ele_type_id,
         effective_start_date eff_date
  FROM   pay_element_types_f
  WHERE  business_group_id = p_business_group_id
  AND    element_name      = p_new_ele_name;

Line: 1920

SELECT pcv_information1 ele_name,
       pcv_information2 ele_type_id,
       pcv_information3 pay_basis
FROM   pqp_configuration_values
WHERE  business_group_id=p_business_group_id
AND    pcv_information_category='PQP_FEDHR_ELEMENT'
--AND   (pcv_information1 <> p_old_ele_name
--OR     pcv_information3 <> p_pay_basis)
ORDER BY pcv_information1 asc;

Line: 1934

SELECT element_name ele_name
FROM   pay_element_types_f
WHERE  element_type_id   = p_ele_type_id
AND    business_group_id = p_bg_id;

Line: 1947

SELECT meaning
FROM   hr_lookups
WHERE  lookup_type='GHR_US_PAY_BASIS'
AND    lookup_code=p_pay_basis;

Line: 1958

SELECT configuration_value_id confg_val_id,
       object_version_number  ovn,
       pcv_information1       ele_name,
       pcv_information3       pay_basis
FROM   pqp_configuration_values
WHERE  ghr_general.return_number(pcv_information2)        = p_ele_type_id
AND    business_group_id       = p_business_group_id
AND    pcv_information_category='PQP_FEDHR_ELEMENT';

Line: 2302

         l_DML := 'Updated';

Line: 2303

           hr_utility.set_location('Element being updated',40);

Line: 2336

	 l_DML := 'Updated';

Line: 2337

         hr_utility.set_location('Element being updated',40);

Line: 2365

      l_DML := 'Inserted';

Line: 2367

      hr_utility.set_location('Element being Inserted',30);

Line: 2490

END update_or_ins_pqp_config_vals;