DBA Data[Home] [Help]

APPS.MSC_ORG_SECURITY dependencies on FND_RESPONSIBILITY

Line 151: from fnd_responsibility_tl resp

147: -- it returns '-1' if no responsibility exists with the given name in MSC
148: lquery_id number ;
149: cursor resp_c is
150: select resp.responsibility_id
151: from fnd_responsibility_tl resp
152: where resp.responsibility_name = p_resp;
153: begin
154: open resp_c;
155: fetch resp_c into p_resp_id;

Line 180: from fnd_responsibility

176: v_statement varchar2(4000);
177:
178: cursor c_resp_appl_id is
179: select application_id
180: from fnd_responsibility
181: where responsibility_id = p_responsibility_id;
182:
183: l_resp_appl_id number;
184: begin

Line 256: from fnd_responsibility

252: v_statement varchar2(2000);
253:
254: cursor c_resp_appl_id is
255: select application_id
256: from fnd_responsibility
257: where responsibility_id = p_responsibility_id;
258:
259: l_resp_appl_id number;
260: begin