APPS.CSM_CUSTMZ_VIEWS_EVENT_PKG dependencies on ASG_USER

Line 48: ASG_USER AU

44: CSM_CUSTOMIZATION_VIEWS BACC --to get cust_view_key,level_id,level_value for that cust_view_id
45: WHERE BACC.CUST_VIEW_ID=ACC.CUST_VIEW_ID
46: AND EXISTS(SELECT 1
47: FROM CSM_CUSTOMIZATION_VIEWS B,
48: ASG_USER AU
49: WHERE B.PAGE_NAME=BACC.PAGE_NAME
50: AND B.REGION_NAME=BACC.REGION_NAME
51: AND B.CUST_VIEW_KEY=BACC.CUST_VIEW_KEY
52: AND ACC.USER_ID = AU.USER_ID

Line 89: ASG_USER AU

85: SELECT AU.USER_ID,
86: B.CUST_VIEW_ID,
87: 1 ACCESS_ID
88: FROM CSM_CUSTOMIZATION_VIEWS B,
89: ASG_USER AU
90: WHERE AU.USER_ID = AU.OWNER_ID
91: AND (
92: (B.LEVEL_ID=10004 AND B.LEVEL_VALUE = AU.USER_ID)
93: OR

Line 132: USER_ID ASG_USER.USER_ID%TYPE,

128:
129:
130: TYPE con_rec_type IS RECORD
131: (
132: USER_ID ASG_USER.USER_ID%TYPE,
133: CUST_VIEW_ID NUMBER,
134: ACCESS_ID NUMBER
135: );
136:

Line 267: ASG_USER AU

263: SELECT AU.USER_ID,
264: B.CUST_VIEW_ID,
265: 1 ACCESS_ID
266: FROM CSM_CUSTOMIZATION_VIEWS B,
267: ASG_USER AU
268: WHERE AU.USER_ID = AU.OWNER_ID
269: AND AU.USER_ID = b_user_id
270: AND (
271: (B.LEVEL_ID=10004 AND B.LEVEL_VALUE = AU.USER_ID)

Line 307: USER_ID ASG_USER.USER_ID%TYPE,

303:
304:
305: TYPE con_rec_type IS RECORD
306: (
307: USER_ID ASG_USER.USER_ID%TYPE,
308: CUST_VIEW_ID NUMBER,
309: ACCESS_ID NUMBER
310: );
311: