DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on FND_USER

Line 4995: ,fnd_user usr

4991: ,usr.employee_id person_id
4992: ,seu.security_user_id
4993: ,seu.object_version_number
4994: FROM per_security_users seu
4995: ,fnd_user usr
4996: WHERE seu.security_profile_id = p_sec_prof_rec.security_profile_id
4997: AND (seu.process_in_next_run_flag = 'Y' OR l_all_static_users = 'Y')
4998: AND seu.user_id = usr.user_id
4999: AND usr.employee_id IS NOT NULL

Line 5012: FROM FND_USER_RESP_GROUPS fusg

5008: IS
5009: SELECT fusg.responsibility_id,
5010: fusg.responsibility_application_id,
5011: fusg.security_group_id
5012: FROM FND_USER_RESP_GROUPS fusg
5013: WHERE fusg.user_id = p_user_id
5014: AND p_effective_date BETWEEN fusg.start_date
5015: AND NVL(fusg.end_date,p_effective_date)
5016: AND EXISTS(

Line 5031: FROM FND_USER_RESP_GROUPS fusg

5027: IS
5028: SELECT fusg.responsibility_id,
5029: fusg.responsibility_application_id,
5030: fusg.security_group_id
5031: FROM FND_USER_RESP_GROUPS fusg
5032: WHERE fusg.user_id = p_user_id
5033: AND p_effective_date BETWEEN fusg.start_date
5034: AND NVL(fusg.end_date,p_effective_date)
5035: AND EXISTS(