DBA Data[Home] [Help]

APPS.PAY_ESU_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 585: -- Validates that the retro_element_type_id exists in pay_element_types_f.

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: --

Line 634: from pay_element_types_f

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))