87: l_ele_rqd_flag varchar2(1);
88:
89: cursor c_ety is
90: select processing_type
91: from pay_element_types_f
92: where element_type_id = l_element_type_id
93: and p_effective_date between effective_start_date
94: and effective_end_date ;
95:
880: elk.effective_end_date
881: from pay_element_entry_values_f elv,
882: pay_element_entries_f ele,
883: pay_element_links_f elk,
884: pay_element_types_f elt
885: where elv.element_entry_value_id = p_element_entry_value_id
886: and elv.element_entry_id = ele.element_entry_id
887: and elv.effective_start_date between ele.effective_start_date
888: and ele.effective_end_date