APPS.HR_HELPDESK_UTIL_SS dependencies on PER_BUSINESS_GROUPS

Line 166: FROM per_business_groups

162: FROM fnd_user_resp_groups
163: WHERE user_id = fnd_global.user_id
164: AND security_group_id =
165: (SELECT security_group_id
166: FROM per_business_groups
167: WHERE business_group_id = bus_grp_id)
168: )
169: )
170: CONNECT BY fme.menu_id = PRIOR fme.sub_menu_id)

Line 242: FROM per_business_groups

238: FROM fnd_user_resp_groups
239: WHERE user_id = fnd_global.user_id
240: AND security_group_id =
241: (SELECT security_group_id
242: FROM per_business_groups
243: WHERE business_group_id = bus_grp_id)
244: )
245: ;
246:

Line 257: FUNCTION get_secgrp_key(bus_grp_id IN PER_BUSINESS_GROUPS.business_group_id%type)

253:
254: END get_resp_name;
255:
256:
257: FUNCTION get_secgrp_key(bus_grp_id IN PER_BUSINESS_GROUPS.business_group_id%type)
258: RETURN VARCHAR2 IS
259:
260: l_secgrp_key fnd_security_groups.SECURITY_GROUP_KEY%type;
261: BEGIN

Line 267: (select security_group_id from PER_BUSINESS_GROUPS

263: SELECT security_group_key
264: INTO l_secgrp_key
265: FROM fnd_security_groups
266: WHERE security_group_id =
267: (select security_group_id from PER_BUSINESS_GROUPS
268: where business_group_id = bus_grp_id);
269:
270: RETURN l_secgrp_key;
271: