[Home] [Help]
722: --
723: CURSOR C_Lookup IS
724: SELECT piv.lookup_type,
725: piv.value_set_id
726: FROM pay_input_values_f piv
727: WHERE piv.input_value_id = p_input_value_id
728: AND nvl(p_effective_date,sysdate)
729: between piv.effective_start_date
730: and piv.effective_end_date;