DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_USER_TABLES

Line 3946: FROM pay_user_tables t

3942: cursor get_code_meaning ( p_municipal_no VARCHAR2, l_eff_date DATE) IS
3943: SELECT hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id,'ZONE')
3944: || ' ' || hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
3945: hr_de_general.get_uci(l_eff_date, t.user_table_id, r.user_row_id, 'MAPPING_ID'))
3946: FROM pay_user_tables t
3947: ,pay_user_rows_f r
3948: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'
3949: AND t.legislation_code = 'NO'
3950: AND r.user_table_id = t.user_table_id