APPS.PN_PROFILE_UPGRADE dependencies on FND_RESPONSIBILITY

Line 261: fnd_responsibility r,

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
264: AND r.responsibility_id = wur.role_orig_system_id (+)
265: AND wur.role_orig_system (+) = 'FND_RESP'

Line 304: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE INDEX BY BINARY_INTEGER;

300: l_exists VARCHAR2(1);
301: l_info_text VARCHAR2(200);
302:
303: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE INDEX BY BINARY_INTEGER;
304: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE INDEX BY BINARY_INTEGER;
305: TYPE Count IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
306:
307: orgids OrgId;
308: respids RespId;

Line 524: fnd_responsibility r,

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
527: AND r.responsibility_id = wur.role_orig_system_id (+)
528: AND wur.role_orig_system (+) = 'FND_RESP'

Line 566: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE;

562: l_multi_org VARCHAR2(1) := 'N';
563: l_exists VARCHAR2(1);
564: l_info_text VARCHAR2(200);
565: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE;
566: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE;
567: TYPE Count IS TABLE OF NUMBER;
568:
569: orgids OrgId;
570: respids RespId;