DBA Data[Home] [Help]

APPS.MSC_ORG_SECURITY dependencies on FND_RESPONSIBILITY

Line 164: from fnd_responsibility_tl resp

160: -- it returns '-1' if no responsibility exists with the given name in MSC
161: lquery_id number ;
162: cursor resp_c is
163: select resp.responsibility_id
164: from fnd_responsibility_tl resp
165: where resp.responsibility_name = p_resp;
166: begin
167: open resp_c;
168: fetch resp_c into p_resp_id;

Line 193: from fnd_responsibility

189: v_statement varchar2(4000);
190:
191: cursor c_resp_appl_id is
192: select application_id
193: from fnd_responsibility
194: where responsibility_id = p_responsibility_id;
195:
196: l_resp_appl_id number;
197: begin

Line 269: from fnd_responsibility

265: v_statement varchar2(2000);
266:
267: cursor c_resp_appl_id is
268: select application_id
269: from fnd_responsibility
270: where responsibility_id = p_responsibility_id;
271:
272: l_resp_appl_id number;
273: begin