APPS.IGS_AD_IMP_002 dependencies on HZ_GEOGRAPHIES

Line 1768: CURSOR region_cd_cur(cp_geography_type hz_geographies.geography_type%TYPE,

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

Line 1769: cp_geography_cd hz_geographies.geography_code%TYPE,

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

Line 1770: cp_country_cd hz_geographies.country_code%TYPE) IS

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

Line 1772: FROM hz_geographies

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: