DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_RESPONSIBILITY

Line 66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;

62:
63: SUBTYPE app_type IS fnd_application%ROWTYPE;
64: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
65: SUBTYPE col_type IS fnd_columns%ROWTYPE;
66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;
67:
68: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
70: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;

Line 1216: FROM fnd_responsibility

1212: get_app(p_application_short_name, l_app);
1213:
1214: SELECT *
1215: INTO x_resp
1216: FROM fnd_responsibility
1217: WHERE application_id = l_app.application_id
1218: AND responsibility_key = p_responsibility_key;
1219: RETURN TRUE;
1220: EXCEPTION

Line 3249: FROM fnd_application a, fnd_responsibility r

3245: WHERE u.user_name = 'SYSADMIN';
3246:
3247: SELECT r.application_id, r.responsibility_id
3248: INTO l_resp_appl_id, l_resp_id
3249: FROM fnd_application a, fnd_responsibility r
3250: WHERE r.application_id = a.application_id
3251: AND a.application_short_name = 'SYSADMIN'
3252: AND r.responsibility_key = 'SYSTEM_ADMINISTRATOR';
3253: