2336: --Territory changes
2337: CURSOR resource_details (p_resource_id NUMBER)
2338: IS
2339: SELECT fu.user_id
2340: FROM jtf_rs_defresources_vl jrd, fnd_user fu
2341: WHERE jrd.resource_id = p_resource_id AND fu.user_id = jrd.user_id;
2342:
2343: CURSOR l_salesrep_csr (p_res_id NUMBER, p_org_id NUMBER)
2344: IS
16920: IS
16921: CURSOR l_fnd_csr (p_user_id NUMBER)
16922: IS
16923: SELECT user_name
16924: FROM fnd_user
16925: WHERE user_id = p_user_id;
16926:
16927: CURSOR get_order_number
16928: IS