DBA Data[Home] [Help]

APPS.FND_FUNCTION_SECURITY dependencies on FND_APPLICATION

Line 236: FROM fnd_application a

232:
233: -- Get application_id
234: SELECT a.application_id
235: INTO application_id
236: FROM fnd_application a
237: WHERE a.application_short_name = responsibility.application;
238:
239: -- Delete if requested
240: IF (delete_flag <> 'N') THEN

Line 274: FROM fnd_data_groups_standard_view dg, fnd_data_group_units dgu, fnd_application a

270: -- Select all other hidden keys
271: -- Data group
272: SELECT dg.data_group_id, a.application_id
273: INTO data_group_id, data_group_application_id
274: FROM fnd_data_groups_standard_view dg, fnd_data_group_units dgu, fnd_application a
275: WHERE dg.data_group_name = responsibility.data_group_name
276: AND dg.data_group_id = dgu.data_group_id
277: AND dgu.application_id = a.application_id
278: AND a.application_short_name = responsibility.data_group_application;

Line 290: FROM fnd_request_groups rg, fnd_application a

286: -- Request group, if supplied
287: IF (request_group_name IS NOT NULL) THEN
288: SELECT rg.request_group_id, a.application_id
289: INTO request_group_id, group_application_id
290: FROM fnd_request_groups rg, fnd_application a
291: WHERE rg.request_group_name = responsibility.request_group_name
292: AND rg.application_id = a.application_id
293: AND a.application_short_name = responsibility.request_group_application;
294: END IF;