APPS.OTA_TDB_BUS dependencies on PER_LETTER_REQUESTS_S

Line 2654: select per_letter_requests_s.nextval

2650: FUNCTION get_letter_request_id (p_letter_type_id in number,
2651: p_event_id in number) return number IS
2652: --
2653: Cursor c_next_id is
2654: select per_letter_requests_s.nextval
2655: from dual;
2656: --
2657: l_request_id number(15);
2658:

Line 2701: select per_letter_requests_s.nextval

2697: where letter_type_id = p_letter_type_id
2698: and request_status = 'PENDING';
2699: --
2700: Cursor c_next_id is
2701: select per_letter_requests_s.nextval
2702: from dual;
2703: --
2704: l_request_id number(15);
2705: l_proc varchar2(72) := g_package||'get_letter_request_id';