32: ,typ.effective_end_date
33: ,nvl(typtl.description,typtl.element_name) use_name
34: ,typ.input_currency_code
35: ,typ.processing_type
36: from pay_element_types_f typ
37: ,pay_element_types_f_tl typtl
38: where typ.element_type_id = p_element_type_id
39: and p_effective_date between
40: typ.effective_start_date and typ.effective_end_date
33: ,nvl(typtl.description,typtl.element_name) use_name
34: ,typ.input_currency_code
35: ,typ.processing_type
36: from pay_element_types_f typ
37: ,pay_element_types_f_tl typtl
38: where typ.element_type_id = p_element_type_id
39: and p_effective_date between
40: typ.effective_start_date and typ.effective_end_date
41: and typ.element_type_id = typtl.element_type_id