eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_DE_GENERAL

Line 579: SELECT hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'ZONE') zone

575: AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
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

Line 581: hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) municipal_name

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'
585: AND t.legislation_code = 'NO'