1170:
1171: /* Get the territory */
1172: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
1173: SELECT *
1174: FROM per_addresses_v
1175: WHERE person_id =pid
1176: and primary_flag='Y';
1177:
1178: rg_csr_get_territory csr_get_territory%rowtype;