APPS.IGS_OR_INST_IMP_003_PKG dependencies on FND_TERRITORIES_VL

Line 585: FROM fnd_territories_vl ter, hz_phone_country_codes hzc

581: c_val_phone_rec c_val_phone%rowtype;
582:
583: CURSOR country_validate (p_country_code IGS_OR_INST_CPHN_INT.COUNTRY_CODE%TYPE)IS
584: SELECT phone_country_code
585: FROM fnd_territories_vl ter, hz_phone_country_codes hzc
586: WHERE ter.territory_code = hzc.territory_code
587: AND hzc.phone_country_code = p_country_code ;
588:
589: country_validate_rec country_validate%ROWTYPE;