APPS.PER_LETTER_TYPES_PKG SQL Statements

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

Line: 19

		select  null
                from per_letter_types
		where upper(p_letter_type) = upper(letter_type_name)
	    	and p_business_group_id = business_group_id + 0
		and (p_letter_type_id is null
		    or (p_letter_type_id is not null
		    and letter_type_id <> p_letter_type_id));

Line: 40

procedure check_delete_letter_type (p_letter_type_id in number) is
--
g_dummy_number    number;

Line: 43

v_no_delete       boolean := FALSE;

Line: 46

	   select null
	   from per_letter_gen_statuses
           where p_letter_type_id = letter_type_id;

Line: 51

	   select null
	   from per_letter_requests
           where p_letter_type_id = letter_type_id;

Line: 61

  v_no_delete := csr_status%found;

Line: 64

  if  v_no_delete then
      hr_utility.set_message (801,'PER_7857_DEF_LETTER_STATUSES');

Line: 71

  v_no_delete := csr_request%found;

Line: 74

  if  v_no_delete then
      hr_utility.set_message (801,'PER_7858_DEF_LETTER_REQUESTS');

Line: 79

end check_delete_letter_type;

Line: 84

cursor c1 is select per_letter_types_s.nextval
	     from sys.dual;

Line: 108

cursor c1 is select concurrent_program_name
             from fnd_concurrent_programs fcp
	     where p_concurrent_program_id = fcp.concurrent_program_id;