APPS.PAY_PYUCSLIS_PKG dependencies on PER_SEC_PROFILE_ASSIGNMENTS_V
Line 5036: SELECT RESPONSIBILITY_ID FROM per_sec_profile_assignments_v
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( 5036: SELECT RESPONSIBILITY_ID FROM per_sec_profile_assignments_v 5037: WHERE user_id = p_user_id
5038: AND security_profile_id = p_security_profile_id
5039: AND responsibility_id = fusg.responsibility_id)
5040: AND rownum = 1;