APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on ASG_USER

Line 54: FROM ASG_USER AU ,

50:
51:
52: CURSOR c_user_id IS
53: SELECT USER_ID
54: FROM ASG_USER AU ,
55: ASG_USER_PUB_RESPS AUPR
56: WHERE AU.USER_NAME = AUPR.USER_NAME
57: AND AU.USER_ID = AU.OWNER_ID
58: AND AUPR.PUB_NAME ='SERVICEP';

Line 55: ASG_USER_PUB_RESPS AUPR

51:
52: CURSOR c_user_id IS
53: SELECT USER_ID
54: FROM ASG_USER AU ,
55: ASG_USER_PUB_RESPS AUPR
56: WHERE AU.USER_NAME = AUPR.USER_NAME
57: AND AU.USER_ID = AU.OWNER_ID
58: AND AUPR.PUB_NAME ='SERVICEP';
59: