APPS.FND_SEC_BULK dependencies on FND_SECURITY_GROUPS

Line 80: fnd_security_groups_vl s

76: from fnd_user u,
77: fnd_user_resp_groups ur,
78: fnd_application_vl a,
79: fnd_responsibility_vl r,
80: fnd_security_groups_vl s
81: where u.user_name = upper(p_template_user)
82: and ur.user_id = u.user_id
83: and ur.responsibility_id = r.responsibility_id
84: and ur.responsibility_application_id = r.application_id

Line 243: from fnd_security_groups

239:
240: if (x_security_group is not null) then
241: begin
242: select security_group_id into secid
243: from fnd_security_groups
244: where security_group_key = x_security_group;
245: exception
246: when no_data_found then
247: fnd_message.set_name('FND', 'FND-INVALID SECURITY');

Line 363: from fnd_security_groups

359:
360: if (x_security_group is not null) then
361: begin
362: select security_group_id into secid
363: from fnd_security_groups
364: where security_group_key = x_security_group;
365: exception
366: when no_data_found then
367: fnd_message.set_name('FND', 'FND-INVALID SECURITY');

Line 444: from fnd_security_groups

440: from fnd_application
441: where application_short_name = x_resp_application;
442:
443: select security_group_id into secid
444: from fnd_security_groups
445: where security_group_key = x_security_group;
446:
447: select responsibility_id into respid
448: from fnd_responsibility

Line 510: from fnd_security_groups

506: from fnd_application
507: where application_id = x_resp_application_id;
508:
509: select security_group_id into secid
510: from fnd_security_groups
511: where security_group_key = x_security_group;
512:
513: -- There was this upgrade script afpnls01.sql which deleted all the
514: -- 107 responsibility from fnd_responsibility table. So, we have to