DBA Data[Home] [Help]

APPS.PN_PROFILE_UPGRADE dependencies on FND_USER

Line 259: FROM fnd_user u,

255: SELECT NVL(v.profile_option_value, g_default_org_id)
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

Line 522: FROM fnd_user u,

518: SELECT NVL(v.profile_option_value, g_default_org_id)
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