DBA Data[Home] [Help]

APPS.PER_ADDRESSES_PKG dependencies on FND_DESCR_FLEX_CONTEXTS

Line 1336: from fnd_descr_flex_contexts_vl

1332: -- global_default to improve performance.
1333:
1334: cursor local_default is
1335: select descriptive_flex_context_name, descriptive_flex_context_code
1336: from fnd_descr_flex_contexts_vl
1337: where (descriptive_flex_context_code = p_legislation_code
1338: or (p_legislation_code = descriptive_flex_context_code
1339: and p_legislation_code in ('CA','US')
1340: and l_geocodes_installed = 'Y'))

Line 1348: from fnd_descr_flex_contexts_vl

1344: ;
1345: --
1346: cursor global_default is
1347: select descriptive_flex_context_name,descriptive_flex_context_code
1348: from fnd_descr_flex_contexts_vl
1349: where substr(descriptive_flex_context_code,1,2)= p_legislation_code
1350: and descriptive_flexfield_name = 'Address Structure'
1351: and application_id = 800 -- bug fix 3648688.
1352: and enabled_flag = 'Y';

Line 1384: , fnd_descr_flex_contexts fdfc

1380:
1381: select ft.territory_short_name
1382: into p_default_country
1383: from fnd_territories_vl ft
1384: , fnd_descr_flex_contexts fdfc
1385: where ft.territory_code = p_legislation_code
1386: and fdfc.descriptive_flex_context_code = ft.territory_code
1387: and fdfc.descriptive_flexfield_name ='Address Structure'
1388: and fdfc.application_id = 800 -- bug fix 3648688