DBA Data[Home] [Help]

APPS.OTA_TDB_BUS dependencies on DUAL

Line 2655: from dual;

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:
2659: --

Line 2702: from dual;

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';
2706: --