DBA Data[Home] [Help]

APPS.CN_USER_ACCESS_PVT dependencies on PER_ALL_PEOPLE_F

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