DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on FND_USER_RESP_GROUPS

Line 115: FROM fnd_user_resp_groups u,

111: SELECT u.RESPONSIBILITY_ID,
112: u.RESPONSIBILITY_APPLICATION_ID
113: INTO l_responsibility_id,
114: l_application_id
115: FROM fnd_user_resp_groups u,
116: fnd_responsibility_vl r
117: WHERE user_id = p_user_id
118: AND r.RESPONSIBILITY_ID = u.RESPONSIBILITY_ID
119: AND u.RESPONSIBILITY_APPLICATION_ID = 9000 -- for dpp