APPS.IGS_AD_IMP_008 dependencies on HZ_PHONE_COUNTRY_CODES

Line 1782: -- HZ_PHONE_COUNTRY_CODEs : HZ F validations -- ssawhney bug 2203778

1778: -- Start ol Local Procedure validate contact
1779: PROCEDURE Validate_Contact(relcon_rec relcon_rec_c%ROWTYPE,l_Check OUT NOCOPY VARCHAR2 ) AS
1780:
1781: -- 4. phone country code is now to be validated against
1782: -- HZ_PHONE_COUNTRY_CODEs : HZ F validations -- ssawhney bug 2203778
1783: CURSOR c_ph_cntry_cd (p_phone_country_code VARCHAR2) IS
1784: SELECT 'X'
1785: FROM HZ_PHONE_COUNTRY_CODES
1786: WHERE PHONE_COUNTRY_CODE = p_phone_country_code;

Line 1785: FROM HZ_PHONE_COUNTRY_CODES

1781: -- 4. phone country code is now to be validated against
1782: -- HZ_PHONE_COUNTRY_CODEs : HZ F validations -- ssawhney bug 2203778
1783: CURSOR c_ph_cntry_cd (p_phone_country_code VARCHAR2) IS
1784: SELECT 'X'
1785: FROM HZ_PHONE_COUNTRY_CODES
1786: WHERE PHONE_COUNTRY_CODE = p_phone_country_code;
1787: l_dummy VARCHAR2(1);
1788: BEGIN
1789: