APPS.ASG_APPLY dependencies on ASG_USER_PUB_RESPS

Line 2169: FROM asg_user_pub_resps pr

2165: WHERE user_name = p_user_name;
2166:
2167: SELECT pr.responsibility_id, pr.app_id
2168: INTO l_respid, l_appid
2169: FROM asg_user_pub_resps pr
2170: WHERE pr.user_name = upper(p_user_name) AND
2171: pr.pub_name = upper(curr_pub) AND
2172: ROWNUM =1;
2173: