APPS.IEC_VALIDATE_PVT dependencies on HZ_PHONE_AREA_CODES

Line 2309: FROM HZ_PHONE_AREA_CODES)

2305:
2306:
2307: FOR cc_rec IN (SELECT DISTINCT PHONE_COUNTRY_CODE, AREA_CODE, TERRITORY_CODE
2308:
2309: FROM HZ_PHONE_AREA_CODES)
2310:
2311: LOOP
2312:
2313: g_cc_ac_tc_lookup_tbl(cc_rec.PHONE_COUNTRY_CODE || cc_rec.AREA_CODE) := cc_rec.TERRITORY_CODE;

Line 6640: FROM HZ_PHONE_AREA_CODES

6636: 'BEGIN
6637:
6638: SELECT DISTINCT AREA_CODE BULK COLLECT INTO :area_code_col
6639:
6640: FROM HZ_PHONE_AREA_CODES
6641:
6642: WHERE PHONE_COUNTRY_CODE = :country_code
6643:
6644: AND AREA_CODE LIKE CONCAT(SUBSTR(:phone_number, 1, 1), ''%'')