APPS.HR_SUM_STORE SQL Statements

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

Line: 98

            l_new_stmt := 'Select distinct p.full_name' || l_columns_to_append || nvl(p_key_col_clause,' ') ||
                           l_new_stmt;

Line: 101

            l_new_stmt := 'Select distinct ''full_name unavail'' ' || l_columns_to_append || nvl(p_key_col_clause,' ') ||
                           l_new_stmt;

Line: 106

            l_new_stmt := 'Select distinct ''full_name unavail'' ' || l_columns_to_append || l_new_stmt;

Line: 108

            l_new_stmt := 'Select distinct p.full_name' || l_columns_to_append || l_new_stmt;