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