APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HR_GENERAL

Line 1446: NVL(fnd.end_time,hr_general.end_of_time)

1442: edtab DATETAB;
1443:
1444: CURSOR get_others
1445: IS SELECT ROWIDTOCHAR(rdb.rowid),
1446: NVL(fnd.end_time,hr_general.end_of_time)
1447: FROM hxc_rdb_logins rdb,
1448: fnd_logins fnd
1449: WHERE rdb.login_id = fnd.login_id
1450: AND rdb.user_id = fnd_global.user_id

Line 1523: AND edtab(i) <> hr_general.end_of_time;

1519: -- can be deleted.
1520: FORALL i IN rowtab.FIRST..rowtab.LAST
1521: DELETE FROM hxc_rdb_logins
1522: WHERE ROWID = CHARTOROWID(rowtab(i))
1523: AND edtab(i) <> hr_general.end_of_time;
1524:
1525:
1526: -- Update any other session to be invalid.
1527: FORALL i IN rowtab.FIRST..rowtab.LAST

Line 1531: AND edtab(i) = hr_general.end_of_time

1527: FORALL i IN rowtab.FIRST..rowtab.LAST
1528: UPDATE hxc_rdb_logins
1529: SET status = 'INVALID'
1530: WHERE ROWID = CHARTOROWID(rowtab(i))
1531: AND edtab(i) = hr_general.end_of_time
1532: RETURNING rowid BULK COLLECT INTO l_tab;
1533:
1534: -- Check if this session is already notified.
1535: -- If notified, no need to send the warning again.