APPS.HRDYNDBI dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 518: to fnd_descriptive_flexs_vl.

514: generating NLS database items.
515: alogue 13-AUG-1997 Business_group_id passed to delete_keyflex_dict
516: to fix bug 513364.
517: nbristow 25-JUL-1997 Changed all references of fn_descriptive_flexs
518: to fnd_descriptive_flexs_vl.
519: mwcallag 26-APR-1995 Entity name passed to delete_keyflex_dict to
520: fix bug 278064.
521: rfine 24-NOV-1994 Suppressed index on business_group_id
522: mwcallag 13-OCT-1994 Route PAYROLL_ACTION_FLEXFIELD_ROUTE deleted.

Line 660: FROM fnd_descriptive_flexs_vl DF,

656: replace (replace (replace (ltrim(rtrim(upper(DF.title))),
657: ' ','_'),'''',''),'.','_') c_title,
658: DFC.created_by c_created_by,
659: DFC.last_update_login c_last_login
660: FROM fnd_descriptive_flexs_vl DF,
661: fnd_descr_flex_contexts DFC
662: WHERE DF.application_table_name = p_table_name
663: AND replace (ltrim (rtrim(DF.title)), '''','') = replace(p_title,'''','')
664: AND DF.application_id IN (800, 801, 804, 805, 808, 8301)

Line 3009: select title from fnd_descriptive_flexs_vl

3005: p_effective_date in date,
3006: p_date_p in varchar2
3007: ) is
3008: cursor get_title is
3009: select title from fnd_descriptive_flexs_vl
3010: where descriptive_flexfield_name = 'Element Developer DF'
3011: and application_id = 801;
3012: --
3013: cursor c_language is

Line 6573: from fnd_descriptive_flexs_vl df,

6569: cursor routes_c is
6570: select df.application_table_name,
6571: rtd.route_name,
6572: rtd.user_key
6573: from fnd_descriptive_flexs_vl df,
6574: pay_route_to_descr_flexs rtd
6575: where df.application_id = rtd.application_id
6576: and df.descriptive_flexfield_name = rtd.descriptive_flexfield_name
6577: and replace (ltrim (rtrim(df.title)), '''','') = p_title;

Line 6585: fnd_descriptive_flexs_vl df

6581: --
6582: cursor bgrp_c (p_table_name varchar2) is
6583: select dfc.descriptive_flex_context_code bus_grp_id
6584: from fnd_descr_flex_contexts dfc,
6585: fnd_descriptive_flexs_vl df
6586: where dfc.application_id = df.application_id
6587: and dfc.descriptive_flexfield_name = df.descriptive_flexfield_name
6588: and df.application_table_name = p_table_name
6589: and replace (ltrim (rtrim(df.title)), '''','') = p_title

Line 6689: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;

6685: (
6686: p_title in varchar2,
6687: p_context in varchar2
6688: ) is
6689: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6690: l_legislation_code hr_org_information_types.legislation_code%type;
6691: l_context hr_org_information_types.org_information_type%type;
6692: l_navigation_method hr_org_information_types.navigation_method%type;
6693: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;

Line 6702: from fnd_descriptive_flexs_vl df,

6698: cursor c_routes is
6699: select df.application_table_name,
6700: rtd.route_name,
6701: rtd.user_key
6702: from fnd_descriptive_flexs_vl df,
6703: pay_route_to_descr_flexs rtd
6704: where df.application_id = rtd.application_id
6705: and df.descriptive_flexfield_name = rtd.descriptive_flexfield_name
6706: and replace (ltrim (rtrim(df.title)), '''','') = p_title

Line 6729: from fnd_descriptive_flexs_vl

6725: BEGIN
6726: --
6727: select descriptive_flexfield_name
6728: into l_flexfield_name
6729: from fnd_descriptive_flexs_vl
6730: where title = p_title
6731: and application_id between 800 and 801;
6732: --
6733: l_legislation_code := get_legislation_code(l_flexfield_name, p_context);

Line 7032: select rtrim(title,'.') from fnd_descriptive_flexs_vl

7028: (
7029: p_payment_id in number
7030: ) is
7031: cursor get_title is
7032: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7033: where descriptive_flexfield_name = 'Paymeth Developer DF';
7034: --
7035: l_context pay_payment_types.payment_type_name%type;
7036: l_context_upper pay_payment_types.payment_type_name%type;