DBA Data[Home] [Help]

APPS.HR_HELPDESK_UTIL_SS dependencies on FND_SECURITY_GROUPS

Line 185: FUNCTION get_secgrp_key(sec_grp_id IN fnd_security_groups.SECURITY_GROUP_KEY%type)

181:
182: END get_resp_name;
183:
184:
185: FUNCTION get_secgrp_key(sec_grp_id IN fnd_security_groups.SECURITY_GROUP_KEY%type)
186: RETURN VARCHAR2 IS
187:
188: l_secgrp_key fnd_security_groups.SECURITY_GROUP_KEY%type;
189: BEGIN

Line 188: l_secgrp_key fnd_security_groups.SECURITY_GROUP_KEY%type;

184:
185: FUNCTION get_secgrp_key(sec_grp_id IN fnd_security_groups.SECURITY_GROUP_KEY%type)
186: RETURN VARCHAR2 IS
187:
188: l_secgrp_key fnd_security_groups.SECURITY_GROUP_KEY%type;
189: BEGIN
190:
191: SELECT security_group_key
192: INTO l_secgrp_key

Line 193: FROM fnd_security_groups

189: BEGIN
190:
191: SELECT security_group_key
192: INTO l_secgrp_key
193: FROM fnd_security_groups
194: WHERE security_group_id = sec_grp_id;
195:
196: RETURN l_secgrp_key;
197: