DBA Data[Home] [Help]

APPS.PN_PROFILE_UPGRADE dependencies on WF_USER_ROLES

Line 260: wf_user_roles wur,

256: org_id,
257: r.responsibility_id resp_id,
258: COUNT(u.user_id) num_users
259: FROM fnd_user u,
260: wf_user_roles wur,
261: fnd_responsibility r,
262: fnd_profile_option_values v
263: WHERE r.application_id = 240
264: AND r.responsibility_id = wur.role_orig_system_id (+)

Line 523: wf_user_roles wur,

519: org_id,
520: r.responsibility_id resp_id,
521: COUNT(u.user_id) num_users
522: FROM fnd_user u,
523: wf_user_roles wur,
524: fnd_responsibility r,
525: fnd_profile_option_values v
526: WHERE r.application_id = 240
527: AND r.responsibility_id = wur.role_orig_system_id (+)