APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_LOOKUPS

Line 106: FROM hr_lookups

102: CURSOR csr_get_tag_descr(l_tag VARCHAR2)
103: IS
104: SELECT meaning
105: ,nvl(start_date_active,fnd_date.canonical_to_date('0001/01/01 00:00:00')) active_date
106: FROM hr_lookups
107: WHERE lookup_type = 'NL_FORM_LABELS'
108: --AND lookup_code like l_tag||'%'
109: AND (lookup_code like l_tag||'%'||g_year OR lookup_code = l_tag)
110: AND nvl(to_char(start_date_active,'RRRR'),'0001') <= g_year

Line 159: FROM hr_lookups

155: AND application_column_name = UPPER(p_node);
156: --
157: CURSOR csr_inv_seg_check(l_tag VARCHAR2) IS
158: SELECT 'N'
159: FROM hr_lookups
160: WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
161: AND lookup_code = upper(l_tag)
162: AND description = l_tag
163: AND enabled_flag = 'Y'

Line 169: FROM hr_lookups

165: AND nvl(to_char(end_date_active,'RRRR'),'4712'));
166:
167: CURSOR csr_replace_tag(l_tag VARCHAR2) IS
168: SELECT description
169: FROM hr_lookups
170: WHERE lookup_type = 'PAY_NL_REPLACEMENT_WR_TAGS'
171: AND lookup_code = upper (l_tag)
172: AND enabled_flag = 'Y'
173: AND (g_year BETWEEN to_char(start_date_active,'RRRR')

Line 178: l_replace hr_lookups.description%TYPE;

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
181: --
182: IF (p_context_code <> p_node) THEN

Line 269: FROM hr_lookups

265: AND application_column_name = UPPER (p_node);
266:
267: CURSOR csr_inv_seg_check(l_tag VARCHAR2) IS
268: SELECT 'N'
269: FROM hr_lookups
270: WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
271: AND lookup_code = upper(l_tag)
272: AND description = l_tag
273: AND enabled_flag = 'Y'

Line 279: FROM hr_lookups

275: AND nvl(to_char(end_date_active,'RRRR'),'4712'));
276:
277: CURSOR csr_replace_tag(l_tag VARCHAR2) IS
278: SELECT description
279: FROM hr_lookups
280: WHERE lookup_type = 'PAY_NL_REPLACEMENT_WR_TAGS'
281: AND lookup_code = upper(l_tag)
282: AND enabled_flag = 'Y'
283: AND (g_year BETWEEN to_char(start_date_active,'RRRR')

Line 291: l_replace hr_lookups.description%TYPE;

287: l_proc_name VARCHAR2(100);
288: l_tag_name VARCHAR2(500);
289: l_data pay_action_information.action_information1%TYPE;
290: l_display VARCHAR2(1);
291: l_replace hr_lookups.description%TYPE;
292:
293: --
294: BEGIN
295: --