APPS.PER_LETTER_TYPES_PKG dependencies on PER_LETTER_REQUESTS

Line 52: from per_letter_requests

48: where p_letter_type_id = letter_type_id;
49: --
50: cursor csr_request is
51: select null
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

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;