DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1323: SELECT 'Y' from jtf_rs_role_relations

1319:
1320: FUNCTION role_used(p_role_id IN NUMBER) return boolean IS
1321: l_exists varchar2(1) := 'N';
1322: CURSOR c_role IS
1323: SELECT 'Y' from jtf_rs_role_relations
1324: WHERE role_id = p_role_id
1325: AND NVL(DELETE_FLAG,'N') <> 'Y';
1326: BEGIN
1327: OPEN c_role;