DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_UNSUCCESSFUL_LOGINS

Line 1002: from fnd_unsuccessful_logins ul, fnd_user u

998: -- Bug 7169414 - rewrite - changed query to be the same used in the Forms login
999:
1000: select count(ul.USER_ID)
1001: into number_of_unsuccessful_logins
1002: from fnd_unsuccessful_logins ul, fnd_user u
1003: where u.user_id = l_user_id
1004: and ul.user_id = u.user_id
1005: and ul.attempt_time > nvl(u.last_logon_date, u.last_update_date);
1006: