DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_RSEA dependencies on PAY_USER_TABLES

Line 467: FROM pay_user_tables t

463: IS
464: SELECT hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'ZONE') zone
465: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
466: hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) municipal_name
467: FROM pay_user_tables t
468: ,pay_user_rows_f r
469: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'
470: AND t.legislation_code = 'NO'
471: AND r.user_table_id = t.user_table_id