308: l_udt_value VARCHAR2(1):= '?';
309: CURSOR csr_get_emp_cat_code (p_effective_date DATE) IS
310: SELECT extv.value
311: FROM pay_user_tables tbls
312: ,pay_user_columns asgc
313: ,pay_user_columns extc
314: ,pay_user_rows_f urws
315: ,pay_user_column_instances_f asgv
316: ,pay_user_column_instances_f extv
309: CURSOR csr_get_emp_cat_code (p_effective_date DATE) IS
310: SELECT extv.value
311: FROM pay_user_tables tbls
312: ,pay_user_columns asgc
313: ,pay_user_columns extc
314: ,pay_user_rows_f urws
315: ,pay_user_column_instances_f asgv
316: ,pay_user_column_instances_f extv
317: WHERE tbls.user_table_name =