DBA Data[Home] [Help]

APPS.BIS_UTIL dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 2265: security group id for this combination from FND_USER_RESP_GROUPS_DIRECT

2261: END get_respId_for_measure_report;
2262:
2263: /*
2264: Takes as input user id and responsibility id, and returns the first
2265: security group id for this combination from FND_USER_RESP_GROUPS_DIRECT
2266: */
2267: FUNCTION get_sec_grp_id_for_user_role (
2268: p_resp_id IN NUMBER
2269: , p_user_id IN NUMBER

Line 2277: FROM fnd_user_resp_groups_direct

2273: l_sec_grp_id NUMBER;
2274:
2275: CURSOR c_sec_grp_id IS
2276: SELECT security_group_id
2277: FROM fnd_user_resp_groups_direct
2278: WHERE user_id = p_user_id
2279: AND responsibility_id = p_resp_id
2280: AND rownum < 2;
2281: BEGIN