APPS.IEC_VALIDATE_PVT dependencies on HZ_PHONE_AREA_CODES

Line 2331: FROM HZ_PHONE_AREA_CODES)

2327:
2328:
2329: FOR cc_rec IN (SELECT DISTINCT PHONE_COUNTRY_CODE, AREA_CODE, TERRITORY_CODE
2330:
2331: FROM HZ_PHONE_AREA_CODES)
2332:
2333: LOOP
2334:
2335: g_cc_ac_tc_lookup_tbl(cc_rec.PHONE_COUNTRY_CODE || cc_rec.AREA_CODE) := cc_rec.TERRITORY_CODE;

Line 6662: FROM HZ_PHONE_AREA_CODES

6658: 'BEGIN
6659:
6660: SELECT DISTINCT AREA_CODE BULK COLLECT INTO :area_code_col
6661:
6662: FROM HZ_PHONE_AREA_CODES
6663:
6664: WHERE PHONE_COUNTRY_CODE = :country_code
6665:
6666: AND AREA_CODE LIKE CONCAT(SUBSTR(:phone_number, 1, 1), ''%'')