APPS.CSM_QUERY_EVENT_PKG dependencies on ASG_USER

Line 44: ASG_USER au

40: SELECT CSM_QUERY_ACC_S.NEXTVAL,
41: au.USER_ID,
42: b.QUERY_ID
43: FROM CSM_QUERY_B b,
44: ASG_USER au
45: WHERE ( (b.LEVEL_ID = 10003 AND b.LEVEL_VALUE = au.responsibility_id)--Support for Responsiblity
46: OR (b.LEVEL_ID = 10004 AND b.LEVEL_VALUE = au.USER_ID)
47: OR (b.LEVEL_ID = 10001 AND b.LEVEL_VALUE =0) )
48: AND au.USER_ID = au.OWNER_ID

Line 548: ASG_USER au

544: SELECT CSM_QUERY_ACC_S.NEXTVAL,
545: au.USER_ID,
546: b.QUERY_ID
547: FROM CSM_QUERY_B b,
548: ASG_USER au
549: WHERE ( (b.LEVEL_ID = 10003 AND b.LEVEL_VALUE = au.responsibility_id)--Support for Responsiblity
550: OR (b.LEVEL_ID = 10004 AND b.LEVEL_VALUE = au.USER_ID)--Saved Query
551: OR (b.LEVEL_ID = 10001 AND b.LEVEL_VALUE =0) )--Site level
552: AND au.USER_ID = c_user_id