DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on ASG_USER

Line 402: FROM ASG_USER au

398: PROCEDURE POPULATE_ACCESS_RECORDS ( p_userid IN NUMBER)
399: IS
400: CURSOR l_resp_csr(b_userid NUMBER) IS
401: SELECT DISTINCT aupr.RESPONSIBILITY_ID AS RESPONSIBILITY_ID
402: FROM ASG_USER au
403: , asg_user_pub_resps aupr
404: WHERE au.USER_ID = b_userid
405: AND aupr.pub_name = 'SERVICEP'
406: AND au.user_name = aupr.user_name;

Line 403: , asg_user_pub_resps aupr

399: IS
400: CURSOR l_resp_csr(b_userid NUMBER) IS
401: SELECT DISTINCT aupr.RESPONSIBILITY_ID AS RESPONSIBILITY_ID
402: FROM ASG_USER au
403: , asg_user_pub_resps aupr
404: WHERE au.USER_ID = b_userid
405: AND aupr.pub_name = 'SERVICEP'
406: AND au.user_name = aupr.user_name;
407: