APPS.CSM_HTML5_PKG dependencies on ASG_USER_PUB_RESPS

Line 3402: FROM asg_user_pub_resps pr ,asg_user au

3398: END IF;
3399:
3400: SELECT au.user_id,pr.responsibility_id, pr.app_id
3401: INTO l_userid,l_respid,l_appid
3402: FROM asg_user_pub_resps pr ,asg_user au
3403: WHERE pr.user_name = upper(p_user_name)
3404: AND au.user_name=pr.user_name
3405: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3406:

Line 3541: FROM asg_user_pub_resps pr ,asg_user au

3537: l_orig_app_id := fnd_global.resp_appl_id();
3538:
3539: SELECT au.user_id,pr.responsibility_id, pr.app_id
3540: INTO l_user_id,l_resp_id,l_app_id
3541: FROM asg_user_pub_resps pr ,asg_user au
3542: WHERE pr.user_name = upper(p_user_name)
3543: AND au.user_name=pr.user_name
3544: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3545: