APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_LOOKUPS

Line 102: FROM hr_lookups

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

Line 149: FROM hr_lookups

145: AND application_column_name = UPPER(p_node);
146: --
147: CURSOR csr_inv_seg_check(l_tag VARCHAR2) IS
148: SELECT 'N'
149: FROM hr_lookups
150: WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
151: AND lookup_code = upper(l_tag)
152: AND description = l_tag
153: AND enabled_flag = 'Y'

Line 235: FROM hr_lookups

231: AND application_column_name = UPPER (p_node);
232:
233: CURSOR csr_inv_seg_check(l_tag VARCHAR2) IS
234: SELECT 'N'
235: FROM hr_lookups
236: WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
237: AND lookup_code = upper(l_tag)
238: AND description = l_tag
239: AND enabled_flag = 'Y'