APPS.HR_USER_ACCT_INTERNAL dependencies on DUAL

Line 385: FROM sys.dual

381: -- program unit FND_UNIQUE_RESP_KEY.
382: --
383: CURSOR lc_unique_resp_key IS
384: SELECT 1
385: FROM sys.dual
386: WHERE NOT EXISTS
387: (SELECT 1
388: FROM fnd_responsibility
389: WHERE responsibility_key = p_resp_key

Line 397: FROM sys.dual

393: -- program unit FND_UNIQUE_RESP_NAME.
394: --
395: CURSOR lc_unique_resp_name IS
396: SELECT 1
397: FROM sys.dual
398: WHERE NOT EXISTS
399: (SELECT 1
400: FROM fnd_responsibility_vl
401: WHERE responsibility_name = p_resp_name

Line 422: FROM sys.dual;

418: AND application_id = p_request_group_app_id;
419: --
420: CURSOR lc_generate_resp_id IS
421: SELECT fnd_responsibility_s.nextval
422: FROM sys.dual;
423:
424:
425: l_proc varchar2(72) := g_package||'create_fnd_responsibility';
426: l_resp_app_short_name fnd_application.application_short_name%type := null;