APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on FND_RESPONSIBILITY

Line 51: select application_id from fnd_responsibility

47: select application_id from fnd_concurrent_programs
48: where concurrent_program_id = c_conc_program_id;
49:
50: CURSOR c_resp_appl_id (c_resp_id NUMBER) IS
51: select application_id from fnd_responsibility
52: where responsibility_id = c_resp_id;
53: BEGIN
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:

Line 262: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f

258: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
259:
260: CURSOR c_func_exists IS
261: SELECT 'Y'
262: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_form_functions f
263: WHERE r.responsibility_id = fnd_global.resp_id
264: AND r.application_id=fnd_global.resp_appl_id
265: AND r.menu_id = m.menu_id
266: AND m.function_id = f.function_id

Line 814: and (select count(1) from fnd_responsibility resp

810: cursor c_chk_ambiguous_resp is
811: select intf.cst_interface_id
812: from amw_constraint_interface intf
813: where intf.batch_id=p_batch_id
814: and (select count(1) from fnd_responsibility resp
815: where resp.responsibility_id = intf.cst_entries_resp_id
816: and resp.START_DATE <= SYSDATE
817: and (resp.END_DATE >= SYSDATE OR resp.END_DATE IS NULL)
818: )>1;