APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on HZ_GEOGRAPHIES

Line 2069: FROM hz_geographies

2065: NULL L_ATTRIBUTE15,
2066: NULL L_ATTRIBUTE_CATEGORY,
2067: 'COUNTRY' L_PARENT_GEOGRAPHY_TYPE,
2068: (SELECT geography_id
2069: FROM hz_geographies
2070: WHERE country_code = asp.default_country
2071: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2072: 'N' L_ALLOW_MASS_CREATE_FLAG,
2073: 'P' L_APPLIED_AMT_HANDLING_FLAG,

Line 2483: FROM hz_geographies

2479: NULL L_ATTRIBUTE15,
2480: NULL L_ATTRIBUTE_CATEGORY,
2481: 'COUNTRY' L_PARENT_GEOGRAPHY_TYPE,
2482: (SELECT geography_id
2483: FROM hz_geographies
2484: WHERE country_code = asp.default_country
2485: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2486: 'N' L_ALLOW_MASS_CREATE_FLAG,
2487: 'P' L_APPLIED_AMT_HANDLING_FLAG,

Line 6244: FROM hz_geographies

6240:
6241: BEGIN
6242: SELECT geography_id
6243: INTO l_geography_id
6244: FROM hz_geographies
6245: WHERE geography_type = 'COUNTRY'
6246: AND country_code = p_country_code;
6247:
6248: INSERT ALL