DBA Data[Home] [Help]

APPS.CN_USER_ACCESS_PVT dependencies on FND_RESPONSIBILITY

Line 331: fnd_responsibility_vl r, per_all_people_f p

327:
328: cursor get_data (c_fm_resp_key IN VARCHAR2) is
329: SELECT DISTINCT f.user_id, p.full_name, f.user_name
330: FROM fnd_user_resp_groups fr, fnd_user f,
331: fnd_responsibility_vl r, per_all_people_f p
332: WHERE f.user_id = fr.user_id
333: AND fr.responsibility_id = r.responsibility_id
334: AND r.application_id = 283
335: AND r.responsibility_key = c_fm_resp_key

Line 343: FROM fnd_responsibility

339: ORDER BY 3,2;
340:
341: cursor get_resp IS
342: SELECT responsibility_id, responsibility_key
343: FROM fnd_responsibility
344: WHERE application_id = 283
345: AND sysdate BETWEEN start_date AND nvl(end_date, sysdate)
346: ;
347: