1764: FROM igs_pe_person_id_typ
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';
1767:
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,
1769: cp_geography_cd hz_geographies.geography_code%TYPE,
1770: cp_country_cd hz_geographies.country_code%TYPE) IS
1771: SELECT 'X'
1772: FROM hz_geographies
1765: WHERE person_id_type = cp_person_id_type
1766: AND closed_ind = 'N';
1767:
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,
1769: cp_geography_cd hz_geographies.geography_code%TYPE,
1770: cp_country_cd hz_geographies.country_code%TYPE) IS
1771: SELECT 'X'
1772: FROM hz_geographies
1773: WHERE GEOGRAPHY_TYPE = cp_geography_type
1766: AND closed_ind = 'N';
1767:
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,
1769: cp_geography_cd hz_geographies.geography_code%TYPE,
1770: cp_country_cd hz_geographies.country_code%TYPE) IS
1771: SELECT 'X'
1772: FROM hz_geographies
1773: WHERE GEOGRAPHY_TYPE = cp_geography_type
1774: AND geography_code = cp_geography_cd
1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,
1769: cp_geography_cd hz_geographies.geography_code%TYPE,
1770: cp_country_cd hz_geographies.country_code%TYPE) IS
1771: SELECT 'X'
1772: FROM hz_geographies
1773: WHERE GEOGRAPHY_TYPE = cp_geography_type
1774: AND geography_code = cp_geography_cd
1775: AND country_code = cp_country_cd;
1776: