393: --
394: -- Do not select reversal entries
395: --
396: select 1
397: from pay_element_links_f LINK,
398: pay_element_types_f TYPE
399: where link.element_link_id = entry.element_link_id
400: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
401: and link.element_type_id = type.element_type_id
1113: --
1114: -- Do not select reversal entries
1115: --
1116: select 1
1117: from pay_element_links_f LINK,
1118: pay_element_types_f TYPE
1119: where link.element_link_id = entry.element_link_id
1120: and entry.effective_start_date between link.effective_start_date
1121: and link.effective_end_date