APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_GENERAL

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

576: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
577: --
578: CURSOR csr_get_mun_dtls(p_municipal_no VARCHAR2, l_effective_date DATE) IS
579: SELECT hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'ZONE') zone
580: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
581: hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) municipal_name
582: FROM pay_user_tables t
583: ,pay_user_rows_f r
584: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'

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

2069: --
2070: -- Footnote section for Pension Calculated Employer Contribution
2071: IF l_pension_footnote = 1 THEN
2072: g_xml_element_table(l_xml_element_count).tagname := 'FOOT_NOTE';
2073: g_xml_element_table(l_xml_element_count).tagvalue := '*) ' || HR_GENERAL.DECODE_LOOKUP('NO_FORM_LABELS','PENSION_FOOTNOTE');
2074: l_xml_element_count := l_xml_element_count + 1;
2075: END IF;
2076: --
2077: g_xml_element_table(l_xml_element_count).tagname := 'LEGAL_EMPLOYER';