APPS.ZPB_USER_UPDATE dependencies on ZPB_BUSAREA_USERS

Line 642: --remove expired admin accounts from ZPB_BUSAREA_USERS table and then ...

638: from fnd_responsibility
639: where responsibility_key = SCHEMA_ADMIN);
640:
641: ----------------------------------------------------------------------------------------------------------------*/
642: --remove expired admin accounts from ZPB_BUSAREA_USERS table and then ...
643: update_admin_entries(p_business_area_id);
644: --
645: -- Catch new users who have already been added to BA:
646: --

Line 737: zpb_busarea_users e

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
740: AND a.resp_id = d.responsibility_id
741: AND a.user_id = d.user_id

Line 778: from ZPB_BUSAREA_USERS A,

774: FND_GLOBAL.USER_ID,
775: FND_GLOBAL.LOGIN_ID,
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

Line 804: from ZPB_BUSAREA_USERS B

800: set ACCOUNT_STATUS = CURRENT_USER
801: where A.BUSINESS_AREA_ID = p_business_area_id
802: and A.USER_ID in
803: (select B.USER_ID
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

Line 816: from ZPB_BUSAREA_USERS B

812: update ZPB_ACCOUNT_STATES A
813: set ACCOUNT_STATUS = CURRENT_USER
814: where A.BUSINESS_AREA_ID = p_business_area_id
815: and exists (select B.USER_ID
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

Line 900: -- Procedure will remove entries in ZPB_BUSAREA_USERS table

896:
897: end synch_security_users;
898:
899: --
900: -- Procedure will remove entries in ZPB_BUSAREA_USERS table
901: -- when the administrator account has been expired.
902: --
903: procedure update_admin_entries (p_business_area_id in number)
904: is

Line 907: delete from zpb_busarea_users

903: procedure update_admin_entries (p_business_area_id in number)
904: is
905: begin
906:
907: delete from zpb_busarea_users
908: where user_id = (
909: select user_id
910: from zpb_busarea_users
911: where business_area_id = p_business_area_id

Line 910: from zpb_busarea_users

906:
907: delete from zpb_busarea_users
908: where user_id = (
909: select user_id
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