APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_GENERAL

Line 542: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',

538: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
539: --
540: CURSOR csr_get_mun_dtls(p_municipal_no VARCHAR2, l_effective_date DATE) IS
541: SELECT hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'ZONE') zone
542: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
543: hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) municipal_name
544: FROM pay_user_tables t
545: ,pay_user_rows_f r
546: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'

Line 1845: g_xml_element_table(l_xml_element_count).tagvalue := '*) ' || HR_GENERAL.DECODE_LOOKUP('NO_FORM_LABELS','PENSION_FOOTNOTE');

1841: --
1842: -- Footnote section for Pension Calculated Employer Contribution
1843: IF l_pension_footnote = 1 THEN
1844: g_xml_element_table(l_xml_element_count).tagname := 'FOOT_NOTE';
1845: g_xml_element_table(l_xml_element_count).tagvalue := '*) ' || HR_GENERAL.DECODE_LOOKUP('NO_FORM_LABELS','PENSION_FOOTNOTE');
1846: l_xml_element_count := l_xml_element_count + 1;
1847: END IF;
1848: --
1849: g_xml_element_table(l_xml_element_count).tagname := 'LEGAL_EMPLOYER';