DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on PAY_USER_TABLES

Line 544: FROM pay_user_tables t

540: CURSOR csr_get_mun_dtls(p_municipal_no VARCHAR2, l_effective_date DATE) IS
541: SELECT hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'ZONE') zone
542: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',
543: hr_de_general.get_uci(l_effective_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) municipal_name
544: FROM pay_user_tables t
545: ,pay_user_rows_f r
546: WHERE t.user_table_name = 'NO_TAX_MUNICIPALITY'
547: AND t.legislation_code = 'NO'
548: AND r.user_table_id = t.user_table_id