APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 150: FROM fnd_descr_flex_col_usage_tl

146: ,p_node VARCHAR2) RETURN VARCHAR2 AS
147: --
148: CURSOR csr_get_tag_name IS
149: SELECT TRANSLATE ((description), ' /','__') tag_name
150: FROM fnd_descr_flex_col_usage_tl
151: WHERE application_id = 801
152: AND source_lang = 'US'
153: AND descriptive_flexfield_name = 'Action Information DF'
154: AND descriptive_flex_context_code = p_context_code

Line 176: l_tag_name fnd_descr_flex_col_usage_tl.description%TYPE;

172: AND enabled_flag = 'Y'
173: AND (g_year BETWEEN to_char(start_date_active,'RRRR')
174: AND nvl(to_char(end_date_active,'RRRR'),'4712'));
175:
176: l_tag_name fnd_descr_flex_col_usage_tl.description%TYPE;
177: l_display VARCHAR2(1);
178: l_replace hr_lookups.description%TYPE;
179: --
180: BEGIN

Line 260: FROM fnd_descr_flex_col_usage_tl

256: ,p_data VARCHAR2) AS
257: --
258: CURSOR csr_get_tag_name IS
259: SELECT TRANSLATE ((description), ' /','__') tag_name
260: FROM fnd_descr_flex_col_usage_tl
261: WHERE application_id = 801
262: AND source_lang = 'US'
263: AND descriptive_flexfield_name = 'Action Information DF'
264: AND descriptive_flex_context_code = p_context_code