DBA Data[Home] [Help]

APPS.PAY_BALANCES_UPLOAD_PKG dependencies on DUAL

Line 14: SELECT userenv('sessionid') from dual;

10: where name =p_BG_NAME;
11:
12: --Cursor to determine if session id is present in hr_owner_definitions
13: CURSOR csr_get_session_id IS
14: SELECT userenv('sessionid') from dual;
15:
16: cursor csr_get_hr_sess_id(p_session_id HR_OWNER_DEFINITIONS.SESSION_ID%TYPE) is
17: select session_id
18: from hr_owner_definitions