APPS.PER_APPLICANT_PKG dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 1278: l_style fnd_descr_flex_contexts_vl.descriptive_flex_context_code%TYPE;

1274: p_default_no_desc in out nocopy varchar2,
1275: p_people_group_structure in out nocopy varchar2,
1276: p_method_of_apl_gen in out nocopy varchar2) is
1277: --
1278: l_style fnd_descr_flex_contexts_vl.descriptive_flex_context_code%TYPE;
1279: --
1280: begin
1281: get_db_default_values (p_business_group_id => p_business_group_id
1282: ,p_legislation_code => p_legislation_code

Line 1364: from fnd_descr_flex_contexts_vl

1360: -- cursor c3 modified - "application_id = 800" added to improve performance.
1361:
1362: cursor c3 is
1363: select descriptive_flex_context_name, descriptive_flex_context_code
1364: from fnd_descr_flex_contexts_vl
1365: where (descriptive_flex_context_code = p_legislation_code
1366: or (p_legislation_code = descriptive_flex_context_code
1367: and p_legislation_code in ('CA','US')
1368: and hr_general.chk_geocodes_installed = 'Y'))

Line 1378: from fnd_descr_flex_contexts_vl

1374: -- cursor c6 modified - "application_id = 800" added to improve performance.
1375:
1376: cursor c6 is
1377: select descriptive_flex_context_name,descriptive_flex_context_code
1378: from fnd_descr_flex_contexts_vl
1379: where substr(descriptive_flex_context_code,1,2)= p_legislation_code
1380: and descriptive_flexfield_name = 'Address Structure'
1381: and application_id = 800 -- Bug Fix 3648715
1382: and enabled_flag = 'Y';

Line 2194: l_return_value fnd_descr_flex_contexts_vl.descriptive_flex_context_name%type := null;

2190: end get_territory_short_name ;
2191: --
2192: function get_style_name (p_style in varchar2)
2193: return varchar2 is
2194: l_return_value fnd_descr_flex_contexts_vl.descriptive_flex_context_name%type := null;
2195: --
2196: cursor get_style_name is
2197: select descriptive_flex_context_name
2198: from fnd_descr_flex_contexts_vl

Line 2198: from fnd_descr_flex_contexts_vl

2194: l_return_value fnd_descr_flex_contexts_vl.descriptive_flex_context_name%type := null;
2195: --
2196: cursor get_style_name is
2197: select descriptive_flex_context_name
2198: from fnd_descr_flex_contexts_vl
2199: where descriptive_flex_context_code = p_style;
2200: --
2201: begin
2202: if (p_style is not null) then