APPS.PQP_GB_SWF_VALIDATIONS SQL Statements

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

Line: 31

                select meaning
                from hr_lookups
                where lookup_type = p_lookup_type
                  and lookup_code = p_code ;

Line: 65

         l_query := 'select count(*)
                     from pqp_configuration_values
                      where pcv_information_category = '''|| p_pcv_information_category || '''' ||
                     '  and business_group_id = ''' || p_business_group_id || '''' ||
                     '  and ' || p_information_column || ' = ''' || p_value || '''' ||
                     '  and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
                             ' or  configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';

Line: 111

        l_query := 'select count(*)
                    from pqp_configuration_values
                    where pcv_information_category = '''|| p_pcv_information_category || '''' ||
                     ' and business_group_id = ''' || p_business_group_id || '''' ||
                     ' and ( ' || p_information_start_column || ' between ''' || p_value_start || '''' ||
                                                                    ' and ''' || l_value_end || ''' ' ||
                              ' or ' || nvl(p_information_end_column, p_information_start_column) ||
                                                                 ' between ''' || p_value_start || '''' ||
                                                                     ' and ''' || l_value_end || ''' ' ||
                              ' or ''' ||  p_value_start || ''' between '|| p_information_start_column ||
                                                                  ' and ' || nvl(p_information_end_column, p_information_start_column) ||
                              ' or ''' ||  l_value_end   || ''' between '|| p_information_start_column ||
                                                                  ' and ' || nvl(p_information_end_column, p_information_start_column) ||
                           ' ) ' ||
                     '  and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
                             ' or  configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';

Line: 161

        l_updated_val_end varchar2(100);

Line: 162

        l_updated_val_start varchar2(100);

Line: 166

            l_updated_val_start := 'null';

Line: 168

            l_updated_val_start := ''''||p_value_start||'''';

Line: 172

            l_updated_val_end := l_updated_val_start ;

Line: 174

            l_updated_val_end := ''''||p_value_end||'''';

Line: 177

        l_query := 'select count(*)
                    from pqp_configuration_values
                    where pcv_information_category = '''|| p_pcv_information_category || '''' ||
                     ' and business_group_id = ''' || p_business_group_id || '''' ||
                     ' and ' || p_payscale_column || ' = ''' || p_payscale_value || '''' ||
                     ' and ( ' || l_updated_val_start || ' is null ' ||
                              ' or ' || p_information_start_column || ' is null ' ||
                              ' or ' || p_information_start_column || ' between ' || l_updated_val_start ||
                                                                    ' and ' || l_updated_val_end ||
                              ' or ' || nvl(p_information_end_column, p_information_start_column) ||
                                                                 ' between ' || l_updated_val_start ||
                                                                     ' and ' || l_updated_val_end ||
                              ' or ' ||  l_updated_val_start || ' between '|| p_information_start_column ||
                                                                  ' and ' || nvl(p_information_end_column, p_information_start_column) ||
                              ' or ' ||  l_updated_val_end   || ' between '|| p_information_start_column ||
                                                                  ' and ' || nvl(p_information_end_column, p_information_start_column) ||
                           ' ) ' ||
                     '  and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
                             ' or  configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';

Line: 225

        l_updated_val varchar2(50);

Line: 228

            l_updated_val := 'null';

Line: 230

            l_updated_val := ''''||p_value||'''';

Line: 232

        l_query := 'select count(*)
                    from pqp_configuration_values
                    where pcv_information_category = '''|| p_pcv_information_category || '''' ||
                     ' and business_group_id = ''' || p_business_group_id || '''' ||
                     ' and ( ' || l_updated_val || ' is null ' ||
                              ' or ' || p_information_column || ' is null ' ||
                              ' or ' || p_information_column || ' = ' || l_updated_val ||
                           ' ) ' ||
                     '  and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
                             ' or  configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';

Line: 270

        l_query := 'select count(*)
                   from pqp_configuration_values
                   where pcv_information_category = '''|| p_pcv_information_category || '''' ||
                     ' and business_group_id = ''' || p_business_group_id || '''' ||
                     ' and ' || p_information_column || ' <> ''' || p_value || '''' ||
                     '  and (' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
                             ' or  configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';