DBA Data[Home] [Help]

APPS.PER_ABB_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 277: from pay_element_types_f pet, pay_input_values_f piv

273: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date;
274: --
275: cursor csr_valid_element_type is
276: select 1
277: from pay_element_types_f pet, pay_input_values_f piv
278: where p_input_value_id = piv.input_value_id
279: and p_date_effective between piv.effective_start_date and piv.effective_end_date
280: and piv.element_type_id = pet.element_type_id
281: and p_date_effective between pet.effective_start_date and pet.effective_end_date