DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on FND_USER

Line 2207: ,fnd_user usr

2203: ,usr.employee_id person_id
2204: ,seu.security_user_id
2205: ,seu.object_version_number
2206: FROM per_security_users seu
2207: ,fnd_user usr
2208: WHERE seu.security_profile_id = p_sec_prof_rec.security_profile_id
2209: AND (seu.process_in_next_run_flag = 'Y' OR l_all_static_users = 'Y')
2210: AND seu.user_id = usr.user_id
2211: AND usr.employee_id IS NOT NULL

Line 2223: FROM FND_USER_RESP_GROUPS fusg

2219: IS
2220: SELECT fusg.responsibility_id,
2221: fusg.responsibility_application_id,
2222: fusg.security_group_id
2223: FROM FND_USER_RESP_GROUPS fusg
2224: WHERE fusg.user_id = p_user_id
2225: AND p_effective_date BETWEEN fusg.start_date
2226: AND NVL(fusg.end_date,p_effective_date)
2227: AND rownum = 1;