505: PROCEDURE POPULATE_ACCESS_RECORDS ( p_userid IN NUMBER)
506: IS
507: CURSOR l_resp_csr(b_userid NUMBER) IS
508: SELECT DISTINCT aupr.RESPONSIBILITY_ID AS RESPONSIBILITY_ID
509: FROM ASG_USER au
510: , asg_user_pub_resps aupr
511: WHERE au.USER_ID = b_userid
512: AND aupr.pub_name = 'SERVICEP'
513: AND au.user_name = aupr.user_name;
506: IS
507: CURSOR l_resp_csr(b_userid NUMBER) IS
508: SELECT DISTINCT aupr.RESPONSIBILITY_ID AS RESPONSIBILITY_ID
509: FROM ASG_USER au
510: , asg_user_pub_resps aupr
511: WHERE au.USER_ID = b_userid
512: AND aupr.pub_name = 'SERVICEP'
513: AND au.user_name = aupr.user_name;
514: