DBA Data[Home] [Help]

APPS.AME_MIGRATION_PKG dependencies on FND_RESPONSIBILITY_VL

Line 167: ,fnd_responsibility_vl resp

163: ,userresp.security_group_id
164: ,appl.application_short_name
165: ,sec.security_group_key
166: from fnd_user_resp_groups userresp
167: ,fnd_responsibility_vl resp
168: ,fnd_user users
169: ,fnd_application appl
170: ,fnd_security_groups sec
171: where resp.responsibility_id = userresp.responsibility_id

Line 203: from fnd_responsibility_vl

199: --+
200: cursor get_old_responsibilities is
201: select responsibility_id
202: ,application_id
203: from fnd_responsibility_vl
204: where responsibility_key in ('AMEAPPADM', 'AMEGENUSER', 'AMELIMUSER')
205: and start_date <= sysdate and
206: (end_date is null or end_date > sysdate);
207: --+