475: /* Used to get the Territory Details */
476: CURSOR c_territory_details IS
477: select p.document_code, p.language, p.disclosure_code
478: from GR_COUNTRY_PROFILES p,
479: HZ_LOCATIONS l
480: where p.territory_code = l.country and
481: l.location_id = LocalDeliverydetail.ship_to_location_id;
482: l_territory_details c_territory_details%ROWTYPE;
483:
483:
484: /* Used to get the Country code if there is no territory profile set up */
485: CURSOR c_get_country IS
486: SELECT country
487: FROM HZ_LOCATIONS
488: WHERE location_id = LocalDeliverydetail.ship_to_location_id;
489: CountryRec c_get_country%ROWTYPE;
490:
491: /* Used to get the Latest Details of a Regulatory Item Document */