DBA Data[Home] [Help]

APPS.PER_CAGR_UTILITY_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 165: (p_element_type_id IN pay_element_types_f.element_type_id%TYPE

161: -- |----------------------< multiple_entries_allowed >------------------------|
162: -- ----------------------------------------------------------------------------
163: --
164: FUNCTION multiple_entries_allowed
165: (p_element_type_id IN pay_element_types_f.element_type_id%TYPE
166: ,p_effective_date IN DATE) RETURN BOOLEAN IS
167: --
168: -- Delcare Local Variables
169: --

Line 176: FROM pay_element_types_f p

172: l_flag VARCHAR2(2);
173: --
174: CURSOR csr_multiple_entries_allowed IS
175: SELECT 'X'
176: FROM pay_element_types_f p
177: WHERE p.element_type_id = p_element_type_id
178: AND p.multiple_entries_allowed_flag = 'Y'
179: AND p_effective_date BETWEEN p.effective_start_date
180: AND p.effective_end_date;