306: /*** cursor retrieving list of resources subscribed to publication item ***/
307: CURSOR c_mobile_users
308: IS
309: SELECT res.resource_id
310: FROM asg_pub pub
311: , asg_pub_responsibility pubresp
312: , fnd_user_resp_groups usrresp
313: , fnd_user usr
314: , jtf_rs_resource_extns res
307: CURSOR c_mobile_users
308: IS
309: SELECT res.resource_id
310: FROM asg_pub pub
311: , asg_pub_responsibility pubresp
312: , fnd_user_resp_groups usrresp
313: , fnd_user usr
314: , jtf_rs_resource_extns res
315: , asg_user au