DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_RSEA dependencies on HR_GENERAL

Line 465: ,hr_general.decode_lookup('NO_TAX_MUNICIPALITY',

461:
462: CURSOR csr_get_mun_dtls(p_municipal_no VARCHAR2, l_effective_date DATE )
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'