APPS.PER_GB_PENSRV_SVPN SQL Statements

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

Line: 43

  SELECT business_group_id
  FROM   per_all_assignments_f
  WHERE  assignment_id = c_assignment_id
  AND    c_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 53

  SELECT pcv_information1,pcv_information2
  FROM   pqp_configuration_values pcv,
         pqp_configuration_types pct
  WHERE  pcv.pcv_information_category = pct.configuration_type
  AND    pct.configuration_type = 'PQP_GB_PENSERVER_ELIGBLTY_CONF'
  AND    pcv.business_group_id = c_business_group_id;

Line: 65

  SELECT aei_information1
  FROM   per_assignment_Extra_info
  WHERE  assignment_id = c_assignment_id
  AND    aei_information_category = 'PQP_GB_PENSERV_SVPN';

Line: 74

  SELECT max(to_number(paei.aei_information1))+1
  FROM  per_all_people_f papf,
        per_all_assignments_f paaf,
        per_assignment_extra_info paei
  WHERE papf.NATIONAL_IDENTIFIER = c_ni_number
  AND   papf.person_id = paaf.person_id
  AND   paei.assignment_id = paaf.assignment_id
  AND   paei.aei_information_category = 'PQP_GB_PENSERV_SVPN';

Line: 87

  SELECT papf1.NATIONAL_IDENTIFIER
  FROM  per_all_people_f papf1,
        per_all_assignments_f paaf1
  WHERE paaf1.assignment_id = c_assignment_id
  AND   c_effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
  AND   papf1.person_id = paaf1.person_id
  AND   c_effective_date BETWEEN papf1.effective_start_date AND papf1.effective_end_date;

Line: 99

  SELECT pcv_information4
  FROM  pqp_configuration_values pcv,
        pqp_configuration_types pct
  WHERE pcv.pcv_information_category = pct.configuration_type
  AND   pct.configuration_type = 'PQP_GB_PENSERVER_PAYPOINT_INFO'
  AND   pcv.business_group_id = c_business_group_id;

Line: 110

  SELECT paaf.primary_flag
  FROM  per_all_assignments_f paaf
  WHERE paaf.assignment_id = c_assignment_id
  AND   c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;

Line: 162

       l_query :=   'select '||l_column_name||' '||
                    'from per_all_assignments_f'||' '||
                    'where business_group_id = '||l_bg_id||' '||
                    'and assignment_id = '||g_assignment_id||' ';

Line: 222

             hr_utility.set_location(' inserted successfully :'||l_spn, 100);

Line: 275

    SELECT mtn.configuration_value_id
          ,mtn.configuration_name
          ,mtn.business_group_id
          ,mtn.legislation_code
          ,mtn.pcv_information1               uom
          ,mtn.pcv_information2               is_enabled
          ,def.configuration_value_id         defn_config_value_id
          ,def.configuration_name             defn_config_name
          ,def.business_group_id              defn_bg_id
          ,def.legislation_code               defn_leg_code
          ,def.pcv_information4               defn_custom_function
    FROM   pqp_configuration_values  mtn
          ,pqp_configuration_values  def
    WHERE  mtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
      AND  def.pcv_information_category = 'PQP_ABVM_DEFINITION'
      AND  def.pcv_information1 = mtn.pcv_information1
      AND  mtn.pcv_information2 = 'Y'
      AND  ( mtn.business_group_id = p_business_group_id
            OR
             ( ( mtn.business_group_id IS NULL AND mtn.legislation_code = p_legislation_code )
              AND -- there does not exist a config for this UOM at bg level
               NOT EXISTS
               (SELECT 1
                FROM   pqp_configuration_values bgmtn
                WHERE  bgmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
                  AND  bgmtn.pcv_information1 = mtn.pcv_information1
                  AND  bgmtn.business_group_id = p_business_group_id
               ) -- NOT EXISTS
             ) -- OR
            OR
             ( ( mtn.business_group_id IS NULL AND mtn.legislation_code IS NULL )
              AND -- there does not exist a config for this UOM at a higher level
               NOT EXISTS
               (SELECT 1
                FROM   pqp_configuration_values hlmtn
                WHERE  hlmtn.pcv_information_category = 'PQP_ABVM_MAINTENANCE'
                  AND  hlmtn.pcv_information1 = mtn.pcv_information1
                  AND  ( hlmtn.business_group_id = p_business_group_id
                        OR
                         hlmtn.legislation_code = p_legislation_code
                       )
               ) -- NOT EXISTS
             ) -- OR
           ) -- AND
      AND  ( def.business_group_id = p_business_group_id
            OR
             def.business_group_id IS NULL AND def.legislation_code = p_legislation_code
            OR
             def.business_group_id IS NULL AND def.legislation_code IS NULL
           );

Line: 329

  SELECT 1
    FROM pqp_assignment_attributes_f
   WHERE assignment_id = p_assignment_id
     AND contract_type is NOT NULL
     AND  rownum < 2;

Line: 339

   SELECT 1
   FROM per_assignment_budget_values_f
   WHERE ASSIGNMENT_ID = p_assignment_id
   and unit = p_uom ;

Line: 348

   select assignment_type, business_group_id
   from per_all_assignments_f
   where assignment_id = p_assignment_id
   and p_effective_date between effective_start_date and effective_end_date ;