DBA Data[Home] [Help]

APPS.JTF_MENU_PUB dependencies on FND_RESPONSIBILITY_TL

Line 207: -- from fnd_responsibility_tl t, fnd_responsibility b

203: r.application_id = pp_appid;
204:
205: -- cursor get_responsibilities(pp_menuid number, pp_lang varchar2) is
206: -- select b.responsibility_id, t.responsibility_name
207: -- from fnd_responsibility_tl t, fnd_responsibility b
208: -- where b.responsibility_id = t.responsibility_id and
209: -- b.application_id = t.application_id and
210: -- t.language = pp_lang and
211: -- b.menu_id = pp_menuid;

Line 235: from fnd_responsibility_tl t, fnd_responsibility b

231: --p_responsibility_table(cnt).responsibility_name := c1.responsibility_name;
232: cnt := cnt + 1;
233: p_responsibility_table(cnt).responsibility_id := p_respid;
234: select t.responsibility_name into l_resp_name
235: from fnd_responsibility_tl t, fnd_responsibility b
236: where b.responsibility_id = t.responsibility_id and
237: b.application_id = t.application_id and
238: t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
239: p_responsibility_table(cnt).responsibility_name := l_resp_name;

Line 284: -- from fnd_responsibility_tl t, fnd_responsibility b

280:
281: -- here's the new one, which assumes we use pp_lang instead
282: -- cursor get_responsibilities(pp_menuid number, pp_lang varchar2) is
283: -- select b.responsibility_id, t.responsibility_name
284: -- from fnd_responsibility_tl t, fnd_responsibility b
285: -- where b.responsibility_id = t.responsibility_id and
286: -- b.application_id = t.application_id and
287: -- t.language = pp_lang and
288: -- b.menu_id = pp_menuid;

Line 310: from fnd_responsibility_tl t, fnd_responsibility b

306: --p_responsibility_table(cnt).responsibility_name := c1.responsibility_name;
307: cnt := cnt + 1;
308: p_responsibility_table(cnt).responsibility_id := p_respid;
309: select t.responsibility_name into l_resp_name
310: from fnd_responsibility_tl t, fnd_responsibility b
311: where b.responsibility_id = t.responsibility_id and
312: b.application_id = t.application_id and
313: t.language = t_lang and b.responsibility_id = p_respid and b.application_id = p_appid;
314: p_responsibility_table(cnt).responsibility_name := l_resp_name;