APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on HZ_GEOGRAPHIES

Line 2155: FROM hz_geographies

2151: NULL L_ATTRIBUTE15,
2152: NULL L_ATTRIBUTE_CATEGORY,
2153: 'COUNTRY' L_PARENT_GEOGRAPHY_TYPE,
2154: (SELECT geography_id
2155: FROM hz_geographies
2156: WHERE country_code = asp.default_country
2157: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2158: 'N' L_ALLOW_MASS_CREATE_FLAG,
2159: 'P' L_APPLIED_AMT_HANDLING_FLAG,

Line 2570: FROM hz_geographies

2566: NULL L_ATTRIBUTE15,
2567: NULL L_ATTRIBUTE_CATEGORY,
2568: 'COUNTRY' L_PARENT_GEOGRAPHY_TYPE,
2569: (SELECT geography_id
2570: FROM hz_geographies
2571: WHERE country_code = asp.default_country
2572: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2573: 'N' L_ALLOW_MASS_CREATE_FLAG,
2574: 'P' L_APPLIED_AMT_HANDLING_FLAG,

Line 6256: FROM hz_geographies

6252:
6253: BEGIN
6254: SELECT geography_id
6255: INTO l_geography_id
6256: FROM hz_geographies
6257: WHERE geography_type = 'COUNTRY'
6258: AND country_code = p_country_code;
6259:
6260: INSERT ALL