APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 140: FROM fnd_descr_flex_col_usage_tl

136: ,p_node VARCHAR2) RETURN VARCHAR2 AS
137: --
138: CURSOR csr_get_tag_name IS
139: SELECT TRANSLATE ((description), ' /','__') tag_name
140: FROM fnd_descr_flex_col_usage_tl
141: WHERE application_id = 801
142: AND source_lang = 'US'
143: AND descriptive_flexfield_name = 'Action Information DF'
144: AND descriptive_flex_context_code = p_context_code

Line 157: l_tag_name fnd_descr_flex_col_usage_tl.description%TYPE;

153: AND enabled_flag = 'Y'
154: AND (to_char(start_date_active,'RRRR') <= g_year
155: AND nvl(to_char(end_date_active,'RRRR'),'4712') >= g_year);
156:
157: l_tag_name fnd_descr_flex_col_usage_tl.description%TYPE;
158: l_display VARCHAR2(1);
159: --
160: BEGIN
161: --

Line 226: FROM fnd_descr_flex_col_usage_tl

222: ,p_data VARCHAR2) AS
223: --
224: CURSOR csr_get_tag_name IS
225: SELECT TRANSLATE ((description), ' /','__') tag_name
226: FROM fnd_descr_flex_col_usage_tl
227: WHERE application_id = 801
228: AND source_lang = 'US'
229: AND descriptive_flexfield_name = 'Action Information DF'
230: AND descriptive_flex_context_code = p_context_code