APPS.CSM_PAGE_PERZ_DELTA_EVENT_PKG dependencies on ASG_USER

Line 38: ASG_USER AU

34: ACC.DELTA_CLIENT_VERSION,
35: ACC.FILE_DATA,
36: ACC.USER_ID
37: FROM CSM_PAGE_PERZ_DELTA_ACC ACC,
38: ASG_USER AU
39: WHERE ACC.USER_ID=AU.USER_ID
40: AND AU.USER_ID =AU.OWNER_ID
41: AND EXISTS(SELECT 1
42: FROM CSM_PAGE_PERZ_DELTA CPPD

Line 115: ASG_USER AU

111: CPPD.FILE_DATA,
112: AU.USER_ID
113: FROM CSM_PAGE_PERZ CPP,
114: CSM_PAGE_PERZ_DELTA CPPD,
115: ASG_USER AU
116: WHERE CPP.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
117: AND AU.USER_ID =AU.OWNER_ID
118: AND ( (CPPD.LEVEL_VALUE = AU.USER_ID
119: AND CPPD.LEVEL_ID = 10004)

Line 164: USER_ID ASG_USER.USER_ID%TYPE

160: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
161: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
162: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
163: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
164: USER_ID ASG_USER.USER_ID%TYPE
165: );
166:
167: TYPE l_tab_type IS TABLE OF con_rec_type
168: INDEX BY BINARY_INTEGER;

Line 344: ASG_USER AU

340: CPPD.FILE_DATA,
341: AU.USER_ID
342: FROM CSM_PAGE_PERZ CPP,
343: CSM_PAGE_PERZ_DELTA CPPD,
344: ASG_USER AU
345: WHERE AU.USER_ID=b_user_id
346: AND AU.USER_ID =AU.OWNER_ID
347: AND CPP.PAGE_PERZ_ID = CPPD.PAGE_PERZ_ID
348: AND ( (CPPD.LEVEL_VALUE = AU.USER_ID

Line 388: USER_ID ASG_USER.USER_ID%TYPE

384: DELTA_FILE_TYPE CSM_PAGE_PERZ_DELTA.DELTA_FILE_TYPE%TYPE,
385: DELTA_SERVER_VERSION CSM_PAGE_PERZ_DELTA.DELTA_SERVER_VERSION%TYPE,
386: DELTA_CLIENT_VERSION CSM_PAGE_PERZ_DELTA.DELTA_CLIENT_VERSION%TYPE,
387: FILE_DATA CSM_PAGE_PERZ_DELTA.FILE_DATA%TYPE,
388: USER_ID ASG_USER.USER_ID%TYPE
389: );
390:
391: TYPE l_tab_type IS TABLE OF con_rec_type
392: INDEX BY BINARY_INTEGER;