DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on ASG_USER

Line 509: FROM ASG_USER au

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;

Line 510: , asg_user_pub_resps aupr

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: