DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on FND_LOGINS

Line 433: /* clear data from temporary tables based on fnd_logins. Data less than sysdate will be deleted*/

429: END IF;
430:
431: END clear_all_temp_tab;
432:
433: /* clear data from temporary tables based on fnd_logins. Data less than sysdate will be deleted*/
434:
435: PROCEDURE clear_all_inactive_logins
436: AS
437:

Line 441: FROM fnd_logins fnd, hxc_tcd_timecards hxc

437:
438: CURSOR c_get_inactive_sessions
439: IS
440: SELECT distinct hxc.user_id
441: FROM fnd_logins fnd, hxc_tcd_timecards hxc
442: WHERE
443: hxc.user_id = fnd.login_id
444: AND
445: (fnd.start_time < sysdate - 1 OR fnd.end_time IS NOT NULL);