581: -- -------------------------------------------------------------------------
582: -- {Start Of Comments}
583: --
584: -- Description:
585: -- Validates that the retro_element_type_id exists in pay_element_types_f.
586: --
587: -- Prerequisites:
588: -- None.
589: --
630: -- Cursor to check that a retro component exists.
631: --
632: cursor csr_retro_element_type is
633: select null
634: from pay_element_types_f
635: where element_type_id = p_retro_element_type_id
636: and p_effective_date between effective_start_date
637: and effective_end_date
638: and nvl(legislation_code, nvl(l_legislation_code, l_varchar2))