APPS.ASG_APPLY dependencies on ASG_USER_PUB_RESPS

Line 1980: FROM asg_user_pub_resps pr

1976: WHERE user_name = p_user_name;
1977:
1978: SELECT pr.responsibility_id, pr.app_id
1979: INTO l_respid, l_appid
1980: FROM asg_user_pub_resps pr
1981: WHERE pr.user_name = upper(p_user_name) AND
1982: pr.pub_name = upper(curr_pub) AND
1983: ROWNUM =1;
1984: