APPS.FND_SEC_BULK dependencies on FND_APPLICATION

Line 78: fnd_application_vl a,

74: to_char(ur.end_date, 'YYYY/MM/DD') end_date,
75: ur.description
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

Line 217: from fnd_application

213: -- Add a single responsibility to a group of users
214:
215: begin
216: select application_id into appid
217: from fnd_application
218: where application_short_name = x_resp_application;
219: exception
220: when no_data_found then
221: fnd_message.set_name('FND', 'FND-INVALID APPLICATION');

Line 339: from fnd_application

335: -- Add a single responsibility to a group of users
336:
337: begin
338: select application_id into appid
339: from fnd_application
340: where application_id = x_resp_application_id;
341: exception
342: when no_data_found then
343: fnd_message.set_name('FND', 'FND-INVALID APPLICATION');

Line 440: from fnd_application

436:
437: begin
438:
439: select application_id into appid
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

Line 506: from fnd_application

502:
503: begin
504:
505: select application_id into appid
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