APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on ASG_USER

Line 56: FROM ASG_USER AU ,

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

Line 57: ASG_USER_PUB_RESPS AUPR

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