28: CURSOR c_all_mobile_res IS
29: SELECT asgusr.resource_id
30: FROM asg_pub pub
31: , asg_pub_responsibility pubresp
32: , fnd_user_resp_groups usrresp
33: , fnd_user usr
34: , jtf_rs_resource_extns res
35: , asg_user asgusr
36: WHERE asgusr.resource_id = res.resource_id