APPS.HR_DM_DELETE dependencies on FND_USER

Line 114: -- * FND_USER_RESP_GROUPS

110: -- items are removed via FND APIs:
111: --
112: -- * Local lookups
113: -- * FND_SECURITY_GROUPS
114: -- * FND_USER_RESP_GROUPS
115: --
116: -- Input Parameters
117: -- p_business_group_id - business_group_id to delete
118: --

Line 164: FROM fnd_user_resp_groups rg,

160: SELECT u.user_name username,
161: a.application_short_name resp_app,
162: r.responsibility_key resp_key,
163: s.security_group_key security_group
164: FROM fnd_user_resp_groups rg,
165: fnd_user u,
166: fnd_application a,
167: fnd_responsibility r,
168: fnd_security_groups s

Line 165: fnd_user u,

161: a.application_short_name resp_app,
162: r.responsibility_key resp_key,
163: s.security_group_key security_group
164: FROM fnd_user_resp_groups rg,
165: fnd_user u,
166: fnd_application a,
167: fnd_responsibility r,
168: fnd_security_groups s
169: WHERE rg.user_id = u.user_id

Line 231: -- delete FND_USER_RESP_GROUPS

227: END LOOP;
228: CLOSE csr_lu_type;
229:
230:
231: -- delete FND_USER_RESP_GROUPS
232:
233: OPEN csr_usrresgrp;
234: LOOP
235: FETCH csr_usrresgrp INTO

Line 249: fnd_user_pkg.DelResp(username => l_username,

245: l_resp_app || '/' ||
246: l_resp_key || '/' ||
247: l_security_group || ')');
248:
249: fnd_user_pkg.DelResp(username => l_username,
250: resp_app => l_resp_app,
251: resp_key => l_resp_key,
252: security_group => l_security_group);
253: