APPS.PER_LETTER_TYPES_PKG dependencies on PER_LETTER_GEN_STATUSES

Line 47: from per_letter_gen_statuses

43: v_no_delete boolean := FALSE;
44: --
45: cursor csr_status is
46: select null
47: from per_letter_gen_statuses
48: where p_letter_type_id = letter_type_id;
49: --
50: cursor csr_request is
51: select null

Line 56: -- in the per_letter_gen_statuses and per_letter_requests table

52: from per_letter_requests
53: where p_letter_type_id = letter_type_id;
54: --
55: -- Check there are no dependencies of the letter type record
56: -- in the per_letter_gen_statuses and per_letter_requests table
57: --
58: begin
59: open csr_status;
60: fetch csr_status into g_dummy_number;