APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on ASG_USER

Line 389: FROM asg_user

385:
386: CURSOR l_user_id_csr (p_resourceid IN number)
387: IS
388: SELECT user_id
389: FROM asg_user
390: WHERE resource_id = p_resourceid;
391:
392: CURSOR l_usr_rsrc_list_serial
393: IS

Line 397: FROM asg_user_pub_resps aupr,

393: IS
394: SELECT
395: au.resource_id,
396: au.user_id
397: FROM asg_user_pub_resps aupr,
398: asg_user au
399: WHERE aupr.pub_name = 'SERVICEP'
400: AND au.user_name = aupr.user_name
401: AND au.owner_id = au.user_id

Line 398: asg_user au

394: SELECT
395: au.resource_id,
396: au.user_id
397: FROM asg_user_pub_resps aupr,
398: asg_user au
399: WHERE aupr.pub_name = 'SERVICEP'
400: AND au.user_name = aupr.user_name
401: AND au.owner_id = au.user_id
402: AND au.enabled = 'Y';