APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on FND_TERRITORIES

Line 150: not exists (select 'X' from fnd_territories

146: where adapter_content_source = v_adapter
147: and batch_id = p_batch_id
148: and send_flag = 'Y');
149: /* or
150: not exists (select 'X' from fnd_territories
151: where TERRITORY_CODE = country)
152: );
153: OR
154: country not in

Line 176: and exists (select 'X' from fnd_territories

172: where ad.adapter_id =t.adapter_id
173: and ad.enabled_flag='Y'
174: and t.enabled_flag='Y'
175: and t.default_flag = 'Y')
176: and exists (select 'X' from fnd_territories
177: where TERRITORY_CODE = country)
178: ----End of Bug No:3347996
179: );
180:

Line 192: and exists (select 'X' from fnd_territories

188: and ad.adapter_id =t.adapter_id
189: and ad.enabled_flag='Y'
190: and t.enabled_flag='Y' --Bug No:3347996
191: and t.default_flag = 'Y')
192: and exists (select 'X' from fnd_territories
193: where TERRITORY_CODE = country);
194:
195: cursor addresss_cur_default is select rowid
196: from hz_imp_addresses_int

Line 214: --Bug No:3347996--and not exists (select 'X' from fnd_territories

210: and send_flag= 'Y')
211: );
212: --End of --Bug No:3347996
213:
214: --Bug No:3347996--and not exists (select 'X' from fnd_territories
215: --Bug No:3347996 where TERRITORY_CODE = country);
216:
217: cursor default_adapter is select adapter_id,adapter_content_source,nvl(MAXIMUM_BATCH_SIZE,DEFAULT_BATCH_SIZE),
218: DEFAULT_REPLACE_STATUS_LEVEL