APPS.BIS_RL_PKG dependencies on FND_SECURITY_GROUPS_VL

Line 1347: from FND_SECURITY_GROUPS_VL fsg,

1343: a.responsibility_name,
1344: b.responsibility_application_id,
1345: b.security_group_id,
1346: fsg.SECURITY_GROUP_NAME
1347: from FND_SECURITY_GROUPS_VL fsg,
1348: fnd_responsibility_vl a,
1349: FND_USER_RESP_GROUPS b
1350: where b.user_id = p_user_id
1351: and b.start_date <= sysdate

Line 2260: from FND_SECURITY_GROUPS_VL fsg,

2256: into l_object.responsibility_id,
2257: l_object.resp_appl_id,
2258: l_object.security_group_id,
2259: l_menu_id
2260: from FND_SECURITY_GROUPS_VL fsg,
2261: fnd_responsibility_vl a,
2262: FND_USER_RESP_GROUPS b
2263: where a.responsibility_id = p_resp_id
2264: and b.user_id = p_user_id

Line 2459: from FND_SECURITY_GROUPS_VL fsg,

2455: into l_object.responsibility_id,
2456: l_object.resp_appl_id,
2457: l_object.security_group_id,
2458: l_menu_id
2459: from FND_SECURITY_GROUPS_VL fsg,
2460: fnd_responsibility_vl a,
2461: FND_USER_RESP_GROUPS b
2462: where a.responsibility_id = l_id
2463: and b.user_id = p_user_id

Line 2677: from FND_SECURITY_GROUPS_VL fsg,

2673: into l_object.responsibility_id,
2674: l_object.resp_appl_id,
2675: l_object.security_group_id,
2676: l_menu_id
2677: from FND_SECURITY_GROUPS_VL fsg,
2678: fnd_responsibility_vl a,
2679: FND_USER_RESP_GROUPS b
2680: where a.responsibility_id = p_resp_id
2681: and b.user_id = p_user_id

Line 2875: from FND_SECURITY_GROUPS_VL fsg,

2871: into l_object.responsibility_id,
2872: l_object.resp_appl_id,
2873: l_object.security_group_id,
2874: l_menu_id
2875: from FND_SECURITY_GROUPS_VL fsg,
2876: fnd_responsibility_vl a,
2877: FND_USER_RESP_GROUPS b
2878: where a.responsibility_id = p_resp_id
2879: and b.user_id = p_user_id