APPS.FND_FLEX_DIAGNOSE dependencies on FND_RESPONSIBILITY

Line 16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;

12:
13: SUBTYPE app_type IS fnd_application%ROWTYPE;
14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
15: SUBTYPE col_type IS fnd_columns%ROWTYPE;
16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
19: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
20: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;

Line 998: FROM fnd_responsibility_vl

994: SELECT To_char(responsibility_id) || '/' ||
995: responsibility_key || '/' ||
996: responsibility_name
997: INTO l_return
998: FROM fnd_responsibility_vl
999: WHERE application_id = p_application_id
1000: AND responsibility_id = p_responsibility_id;
1001: RETURN(line_return(l_return));
1002: EXCEPTION

Line 2188: FROM fnd_responsibility r

2184: AND application_id = l_vst_scu.application_id
2185: AND responsibility_id = l_vst_scu.responsibility_id
2186: AND NOT EXISTS
2187: (SELECT null
2188: FROM fnd_responsibility r
2189: WHERE r.application_id = fvru.application_id
2190: AND r.responsibility_id = fvru.responsibility_id);
2191: x_message := SQL%rowcount || ' row(s) deleted.';
2192: GOTO return_success;