DBA Data[Home] [Help]

APPS.IGS_AD_IMP_012 dependencies on HZ_PHONE_COUNTRY_CODES

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

275:
276: PROCEDURE validate_prsn_contacts(c_pc_rec c_pc%ROWTYPE,l_Check OUT NOCOPY VARCHAR2 ) AS
277:
278: -- 4. phone country code is now to be validated against
279: -- HZ_PHONE_COUNTRY_CODEs : HZ F validations -- ssawhney bug 2203778
280: CURSOR c_ph_cntry_cd (p_phone_country_code VARCHAR2) IS
281: SELECT 'X'
282: FROM HZ_PHONE_COUNTRY_CODES
283: WHERE PHONE_COUNTRY_CODE = p_phone_country_code;

Line 282: FROM HZ_PHONE_COUNTRY_CODES

278: -- 4. phone country code is now to be validated against
279: -- HZ_PHONE_COUNTRY_CODEs : HZ F validations -- ssawhney bug 2203778
280: CURSOR c_ph_cntry_cd (p_phone_country_code VARCHAR2) IS
281: SELECT 'X'
282: FROM HZ_PHONE_COUNTRY_CODES
283: WHERE PHONE_COUNTRY_CODE = p_phone_country_code;
284:
285: l_dummy VARCHAR2(1);
286: