APPS.HR_DM_DELETE dependencies on FND_USER_RESP_GROUPS

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 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