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_PAYSLIP_ARCHIVE dependencies on HR_DE_GENERAL

Line 3954: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')

3950:
3951: /* Cursor to get the Zone and meaning from UDT and lookup */
3952:
3953: cursor get_code_meaning ( p_municipal_no VARCHAR2, l_eff_date DATE) IS
3954: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')
3955: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
3956: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))
3957: FROM pay_user_tables t
3958: ,pay_user_rows_f r

Line 3956: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))

3952:
3953: cursor get_code_meaning ( p_municipal_no VARCHAR2, l_eff_date DATE) IS
3954: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')
3955: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
3956: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))
3957: FROM pay_user_tables t
3958: ,pay_user_rows_f r
3959: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'
3960: AND t.legislation_code = 'NO'