DBA Data[Home] [Help]

APPS.CZ_SECURITY_PVT dependencies on FND_RESPONSIBILITY

Line 1249: FROM fnd_responsibility

1245:
1246: BEGIN
1247: SELECT responsibility_id
1248: INTO l_responsibility_id
1249: FROM fnd_responsibility
1250: WHERE responsibility_key = UPPER(p_responsibility)
1251: AND application_id = 708;
1252: RETURN l_responsibility_id;
1253: END get_responsibility_id;

Line 2977: FROM fnd_responsibility_tl

2973: LOOP
2974: FETCH resp_cur INTO l_responsibility_id;
2975: EXIT WHEN resp_cur%NOTFOUND;
2976: SELECT responsibility_name INTO l_resp_name
2977: FROM fnd_responsibility_tl
2978: WHERE responsibility_id = l_responsibility_id
2979: AND language = userenv('LANG');
2980: l_return_str := l_return_str||', '||l_resp_name;
2981: END LOOP;