DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on FND_USER_RESP_GROUPS

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;