APPS.ZPB_USER_UPDATE dependencies on ZPB_USERS

Line 691: -- Procedure that will insert rows into ZPB_USERS for any security

687:
688: end init_user_session;
689:
690: --
691: -- Procedure that will insert rows into ZPB_USERS for any security
692: -- administrators who have access to a business area. Called from
693: -- the business area user's screen
694: --
695: procedure synch_security_users (p_business_area_id in number)

Line 756: insert into ZPB_USERS

752: AND d.responsibility_application_id = n_epbproductid
753: AND c.responsibility_key = 'ZPB_MANAGER_RESP';
754:
755: begin
756: insert into ZPB_USERS
757: (BUSINESS_AREA_ID,
758: USER_ID,
759: LAST_BUSAREA_LOGIN,
760: SHADOW_ID,

Line 789: from ZPB_USERS D

785: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
786: and A.BUSINESS_AREA_ID = p_business_area_id
787: and A.USER_ID not in
788: (select distinct D.USER_ID
789: from ZPB_USERS D
790: where D.BUSINESS_AREA_ID = p_business_area_id);
791:
792: /* ----------------------------------------------------------------------------
793: Replaced this update statement with the following for Bug: 5077013.