DBA Data[Home] [Help]

APPS.CN_USER_ACCESS_PVT dependencies on FND_USER

Line 330: FROM fnd_user_resp_groups fr, fnd_user f,

326: l_org_id VARCHAR2(30);
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