APPS.PER_LETTER_GEN_STATUSES_PKG SQL Statements

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

Line: 20

	select  null
	from    per_letter_gen_statuses x
	where   x.business_group_id + 0     = p_business_group_id
	and     x.assignment_status_type_id = p_assignment_status_type_id
	and     x.letter_type_id        = p_letter_type_id
	and     (p_letter_gen_status_id is null
		or (p_letter_gen_status_id is not null
	           and x.letter_gen_status_id <> p_letter_gen_status_id));

Line: 46

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

Line: 72

  cursor c1 is select nvl(atl.user_status, ttl.user_status)
               from   per_assignment_status_types_tl ttl,
                      per_assignment_status_types t,
                      per_ass_status_type_amends_tl atl,
                      per_ass_status_type_amends a
               where  t.assignment_status_type_id     = p_assignment_status_type_id
               and    a.assignment_status_type_id (+) = t.assignment_status_type_id
               and    a.ass_status_type_amend_id      = atl.ass_status_type_amend_id (+)
               and    decode(atl.ass_status_type_amend_id, null, '1', userenv('LANG')) =
                      decode(atl.ass_status_type_amend_id, null, '1', atl.LANGUAGE)
               and    t.assignment_status_type_id     = ttl.assignment_status_type_id
               and    ttl.LANGUAGE = userenv('LANG');