APPS.IGS_OR_INST_IMP_003_PKG dependencies on FND_TERRITORIES

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;

Line 1588: FROM fnd_territories

1584:
1585: --cursor added to validate country field in address interface table
1586: CURSOR c_adr_val(p_country igs_or_adr_int.country%TYPE) IS
1587: SELECT 'X'
1588: FROM fnd_territories
1589: WHERE territory_code= p_country;
1590:
1591: c_adr_val_rec c_adr_val%ROWTYPE;
1592: