APPS.PQP_GB_CONFIGURATION_VALUE SQL Statements

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

Line: 204

            select 1
            into l_count
            from pqp_configuration_values
            where pcv_information_category = p_pcv_information_category
              and business_group_id = p_business_group_id
              and (p_configuration_value_id is null
                   or  configuration_value_id <> p_configuration_value_id)
              and pcv_information1 = p_pcv_information1 ;

Line: 570

         select pcv_information1
         into l_mapping_lookup
         from pqp_configuration_values
         where business_group_id = p_business_group_id
           and pcv_information_category = l_mapping_info_category
           and rownum<2 ;

Line: 653

         select pcv_information1
         into l_source
         from pqp_configuration_values
         where business_group_id = p_business_group_id
           and pcv_information_category = l_source_info_category ;

Line: 872

            select 1
            into l_count
            from pqp_configuration_values
            where pcv_information_category = p_pcv_information_category
              and business_group_id = p_business_group_id
              and (p_configuration_value_id is null
                   or  configuration_value_id <> p_configuration_value_id)
              and pcv_information1 = p_pcv_information1 ;

Line: 1582

procedure update_configuration_value_bp
                  (p_configuration_value_id         in     number
                  ,p_effective_date                 in     date
                  ,p_business_group_id              in     number
                  ,p_legislation_code               in     varchar2
                  ,p_pcv_information_category       in     varchar2
                  ,p_pcv_information1               in     varchar2
                  ,p_pcv_information2               in     varchar2
                  ,p_pcv_information3               in     varchar2
                  ,p_pcv_information4               in     varchar2
                  ,p_pcv_information5               in     varchar2
                  ,p_pcv_information6               in     varchar2
                  ,p_pcv_information7               in     varchar2
                  ,p_pcv_information8               in     varchar2
                  ,p_pcv_information9               in     varchar2
                  ,p_pcv_information10              in     varchar2
                  ,p_pcv_information11              in     varchar2
                  ,p_pcv_information12              in     varchar2
                  ,p_pcv_information13              in     varchar2
                  ,p_pcv_information14              in     varchar2
                  ,p_pcv_information15              in     varchar2
                  ,p_pcv_information16              in     varchar2
                  ,p_pcv_information17              in     varchar2
                  ,p_pcv_information18              in     varchar2
                  ,p_pcv_information19              in     varchar2
                  ,p_pcv_information20              in     varchar2
                  ,p_object_version_number          in     number
                  ,p_configuration_name             in     varchar2
                   )as
l_proc  varchar2(56);

Line: 1619

  l_proc:='PQP_GB_CONFIGURATION_VALUE.UPDATE_CONFIGURATION_VALUE_BP';