eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_USER_UPDATE dependencies on FND_RESPONSIBILITY

Line 28: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c

24: l_user_exists VARCHAR2(1);
25:
26: cursor usernames is
27: select /*+ LEADING (c) */ distinct(a.user_name) name, a.user_id
28: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c
29: where a.user_id=b.user_id
30: and b.responsibility_id=c.responsibility_id
31: and c.application_id=n_epbproductid;
32:

Line 35: from fnd_responsibility

31: and c.application_id=n_epbproductid;
32:
33: cursor groups is
34: select responsibility_key role
35: from fnd_responsibility
36: where application_id = n_epbproductid;
37:
38: CURSOR expired_user_resp_csr
39: IS

Line 50: fnd_responsibility r

46: UNION
47: SELECT /*+ LEADING (r) */ z.user_id, z.resp_id
48: FROM zpb_account_states z,
49: fnd_user_resp_groups_all u,
50: fnd_responsibility r
51: WHERE z.user_id = u.user_id
52: AND z.resp_id = u.responsibility_id
53: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)
54: AND r.responsibility_id = u.responsibility_id

Line 61: fnd_responsibility u

57: AND r.application_id = n_epbproductid
58: UNION
59: SELECT z.user_id, z.resp_id
60: FROM zpb_account_states z,
61: fnd_responsibility u
62: WHERE z.resp_id = u.responsibility_id
63: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)
64: AND u.responsibility_key <> 'ZPB_MANAGER_RESP'
65: AND z.business_area_id = p_business_area_id

Line 87: fnd_responsibility u

83: AND responsibility_application_id = n_epbproductid
84: UNION
85: SELECT z.user_id, z.resp_id
86: FROM zpb_account_states z,
87: fnd_responsibility u
88: WHERE z.resp_id = u.responsibility_id
89: AND (u.end_date IS NULL OR u.end_date >= SYSDATE)
90: AND z.business_area_id = p_business_area_id
91: AND u.application_id = n_epbproductid;

Line 96: FROM fnd_user_resp_groups a, fnd_responsibility b

92:
93: CURSOR brand_new_user_resp_csr
94: IS
95: SELECT /*+ LEADING (b) */ a.user_id, a.responsibility_id resp_id
96: FROM fnd_user_resp_groups a, fnd_responsibility b
97: WHERE a.responsibility_id = b.responsibility_id
98: AND b.application_id = n_epbproductid
99: MINUS
100: SELECT user_id, resp_id

Line 118: fnd_responsibility c,

114: b2.subject_type resp_sub_type,
115: b2.subject_name resp_sub_name
116: from fnd_user a,
117: fnd_user_resp_groups b,
118: fnd_responsibility c,
119: bism_subjects b1,
120: bism_subjects b2
121: where a.user_id = b.user_id and
122: (c.end_date is NULL or c.end_date > SYSDATE) and

Line 141: fnd_responsibility c

137: minus
138: (select /*+ LEADING (c) */ distinct(a.user_name)
139: from fnd_user a,
140: fnd_user_resp_groups b,
141: fnd_responsibility c
142: where a.user_id=b.user_id
143: and (a.end_date is NULL or a.end_date >= SYSDATE)
144: and b.responsibility_id=c.responsibility_id
145: and c.application_id=n_epbproductid

Line 148: from fnd_responsibility

144: and b.responsibility_id=c.responsibility_id
145: and c.application_id=n_epbproductid
146: union
147: select responsibility_key
148: from fnd_responsibility
149: where application_id = n_epbproductid);
150: --
151: -- Cursor is LEADING because very few rows in zpb_account_states
152: -- should returned at all

Line 160: fnd_responsibility c

156: from zpb_account_states x,
157: bism_subjects y,
158: fnd_user a,
159: fnd_user_resp_groups b,
160: fnd_responsibility c
161: where x.subject_id = y.subject_id
162: and x.business_area_id = p_business_area_id
163: and x.account_status in (EXP_USER, HIDE_ACCOUNT)
164: and x.user_id = a.user_id

Line 186: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c

182: and g.subject_id = s.group_id
183: and s.business_area_id = p_business_area_id
184: minus
185: (select /*+ LEADING (c) */ a.user_name, c.responsibility_key
186: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c
187: where a.user_id = b.user_id
188: and (b.end_date is NULL or b.end_date > SYSDATE)
189: and b.responsibility_id=c.responsibility_id
190: and c.application_id=n_epbproductid);

Line 195: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c,

191:
192: -- roles resinstated for an active user.
193: cursor reinstatedroles is
194: select /*+LEADING (s) */ a.user_name uname, c.responsibility_key gname
195: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c,
196: zpb_account_states s, bism_subjects u, bism_subjects g
197: where a.user_id = b.user_id
198: and (a.end_date is NULL or a.end_date > SYSDATE)
199: and (b.end_date is NULL or b.end_date > SYSDATE)

Line 341: fnd_responsibility b

337:
338: SELECT subject_id
339: INTO l_subj_resp_id
340: FROM bism_subjects a,
341: fnd_responsibility b
342: WHERE a.subject_name = b.responsibility_key
343: AND b.responsibility_id = brand_new_user_resp_rec.resp_id
344: AND a.subject_type = 'g';
345:

Line 638: from fnd_responsibility

634: or account_status = NEW_USER)
635: and business_area_id = p_business_area_id
636: and resp_id = (
637: select unique(responsibility_id)
638: from fnd_responsibility
639: where responsibility_key = SCHEMA_ADMIN);
640:
641: ----------------------------------------------------------------------------------------------------------------*/
642: --remove expired admin accounts from ZPB_BUSAREA_USERS table and then ...

Line 711: fnd_responsibility r

707: UNION
708: SELECT /*+ LEADING (r) */ z.user_id, z.resp_id
709: FROM zpb_account_states z,
710: fnd_user_resp_groups_all u,
711: fnd_responsibility r
712: WHERE z.user_id = u.user_id
713: AND z.resp_id = u.responsibility_id
714: AND z.resp_id = r.responsibility_id
715: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)

Line 722: fnd_responsibility u

718: AND responsibility_application_id = n_epbproductid
719: UNION
720: SELECT z.user_id, z.resp_id
721: FROM zpb_account_states z,
722: fnd_responsibility u
723: WHERE z.resp_id = u.responsibility_id
724: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)
725: AND u.responsibility_key = 'ZPB_MANAGER_RESP'
726: AND z.business_area_id = p_business_area_id

Line 735: fnd_responsibility c,

731: IS
732: SELECT a.user_id, a.resp_id
733: FROM zpb_account_states a,
734: fnd_user b,
735: fnd_responsibility c,
736: fnd_user_resp_groups d,
737: zpb_busarea_users e
738: WHERE a.user_id = b.user_id
739: AND a.resp_id = c.responsibility_id

Line 780: FND_RESPONSIBILITY C

776: sysdate,
777: FND_GLOBAL.USER_ID
778: from ZPB_BUSAREA_USERS A,
779: FND_USER_RESP_GROUPS B,
780: FND_RESPONSIBILITY C
781: where A.USER_ID = B.USER_ID
782: and B.RESPONSIBILITY_APPLICATION_ID = 210
783: and B.RESPONSIBILITY_ID = C.RESPONSIBILITY_ID
784: and C.APPLICATION_ID = 210

Line 808: from FND_RESPONSIBILITY C

804: from ZPB_BUSAREA_USERS B
805: where B.BUSINESS_AREA_ID = p_business_area_id)
806: and A.RESP_ID =
807: (select C.RESPONSIBILITY_ID
808: from FND_RESPONSIBILITY C
809: where C.APPLICATION_ID = 210
810: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP');
811:
812: update ZPB_ACCOUNT_STATES A

Line 820: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

816: from ZPB_BUSAREA_USERS B
817: where B.BUSINESS_AREA_ID = p_business_area_id
818: and b.USER_ID = A.USER_ID)
819: and (A.RESP_ID = (select C.RESPONSIBILITY_ID
820: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
821: where C.APPLICATION_ID = 210
822: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
823: and c.responsibility_id = d.responsibility_id
824: and d.user_id = a.user_id

Line 839: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

835: update ZPB_ACCOUNT_STATES A
836: set ACCOUNT_STATUS = RMV_ROLE
837: where A.BUSINESS_AREA_ID = p_business_area_id
838: and (A.RESP_ID in (select C.RESPONSIBILITY_ID
839: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
840: where C.APPLICATION_ID = 210
841: and c.responsibility_id = d.responsibility_id
842: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
843: and d.user_id = a.user_id

Line 856: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

852: set A.ACCOUNT_STATUS = ADD_ROLE
853: where A.BUSINESS_AREA_ID = p_business_area_id
854: and A.ACCOUNT_STATUS = RMV_ROLE
855: and (A.RESP_ID in (select C.RESPONSIBILITY_ID
856: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
857: where C.APPLICATION_ID = 210
858: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
859: and c.responsibility_id = d.responsibility_id
860: and (d.end_date IS NULL or d.end_date >= sysdate))

Line 914: from fnd_user a,fnd_user_resp_groups b,fnd_responsibility c

910: from zpb_busarea_users
911: where business_area_id = p_business_area_id
912: intersect
913: select /*+ LEADING (c) */ distinct(a.user_id)
914: from fnd_user a,fnd_user_resp_groups b,fnd_responsibility c
915: where a.user_id=b.user_id
916: and b.responsibility_id=c.responsibility_id
917: and c.responsibility_key = 'ZPB_MANAGER_RESP'
918: and ((a.end_date < SYSDATE) or