DBA Data[Home] [Help]

APPS.GMD_FORMULA_DESIGNER_PKG dependencies on FND_RESPONSIBILITY

Line 2253: FND_RESPONSIBILITY rs

2249: -- Cursor to check if user has formula security responsibility.
2250: CURSOR check_fsec_resp IS
2251: SELECT 1
2252: FROM FND_USER_RESP_GROUPS rg ,
2253: FND_RESPONSIBILITY rs
2254: WHERE rg.user_id = fnd_global.user_id
2255: AND rg.responsibility_id = rs.responsibility_id
2256: AND rs.responsibility_key = 'GMD_PD_SECURITY_MGR'
2257: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE)