79: -- Declare Local cursors
80: --
81: cursor csr_hr_look is
82: select null 83: from hr_standard_lookups 84: where lookup_code = p_lookup_code
85: and lookup_type = p_lookup_type
86: and p_effective_date between
87: nvl(start_date_active, p_effective_date)