[Home] [Help]
882: -- Cursor to retrieve the input value information
883: CURSOR csr_get_ipv_info (c_element_type_id NUMBER)
884: IS
885: SELECT input_value_id
886: FROM pay_input_values_f
887: WHERE NAME = p_input_value_name
888: AND element_type_id = c_element_type_id
889: AND p_effective_date BETWEEN effective_start_date
890: AND effective_end_date;