APPS.PQP_CONFIG_INFO_PKG SQL Statements

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

Line: 12

SELECT put.user_table_name
  FROM pay_user_tables put
 WHERE put.business_group_id=p_business_group_id
   AND put.user_table_id    =p_table_id;

Line: 40

SELECT pet.element_name
  FROM pay_element_types_f pet
 WHERE pet.element_type_id =p_element_id
   AND pet.business_group_id=p_business_group_id
   AND sysdate BETWEEN pet.effective_start_date
                   AND pet.effective_end_date;

Line: 80

SELECT  pcv.pcv_information_category
       , pqp_gb_mileage_claim_pkg.get_lkp_meaning
         (pcv.pcv_information1,'PQP_VEHICLE_OWNERSHIP_TYPE')
          Ownership
       ,RPAD(DECODE (pcv.pcv_information1,'C',
         pqp_gb_mileage_claim_pkg.get_lkp_meaning
          (pcv.pcv_information2,'PQP_COMPANY_VEHICLE_USER'),
          'P',pqp_gb_mileage_claim_pkg.get_lkp_meaning
          (pcv.pcv_information2,'PQP_PRIVATE_VEHICLE_USER')
           ),10) Usage_type
       , RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
          (pcv.pcv_information3 ,'PQP_VEHICLE_TYPE'),10)
        Vehicle_type
       ,RPAD(pqp_gb_mileage_claim_pkg.get_lkp_meaning
         (pcv.pcv_information4,'PQP_FUEL_TYPE'),21)
         Fuel_type
       ,RPAD(get_user_table_name(
         TO_NUMBER(pcv.pcv_information5),
                   p_business_group_id),35) rates_type
       ,RPAD(get_element_name(
         TO_NUMBER(pcv.pcv_information6),
             p_business_group_id),60) element_name
  FROM pqp_configuration_values pcv
 WHERE business_group_id=p_business_group_id;

Line: 115

  SELECT count(*)
    INTO l_count
    FROM pqp_configuration_values pcv
   WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
     AND pcv.pcv_information1 =p_ownership
     AND pcv.pcv_information2 =p_usage_type
     AND pcv.pcv_information3 =p_vehicle_type
     AND pcv.pcv_information4 =p_fuel_type
     AND pcv.business_group_id=p_business_group_id;

Line: 146

  SELECT configuration_value_id
        ,object_version_number
    INTO l_configuration_value_id
        ,l_object_version_number
    FROM pqp_configuration_values pcv
   WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
     AND pcv.pcv_information1 =p_ownership
     AND pcv.pcv_information2 =p_usage_type
     AND pcv.pcv_information3 =p_vehicle_type
     AND pcv.pcv_information4 =p_fuel_type
     AND pcv.business_group_id=p_business_group_id;

Line: 178

  SELECT configuration_value_id
        ,object_version_number
    INTO l_configuration_value_id
        ,l_object_version_number
    FROM pqp_configuration_values pcv
   WHERE pcv.pcv_information_category ='GB_VEHICLE_CALC_INFO'
     AND pcv.pcv_information1 =p_ownership
     AND pcv.pcv_information2 =p_usage_type
     AND pcv.pcv_information3 =p_vehicle_type
     AND pcv.pcv_information4 =p_fuel_type
     AND pcv.business_group_id=p_business_group_id;