983: ) is
984: select screen_entry_value
985: ,effective_start_date
986: ,effective_end_date
987: from pay_element_entry_values_f pee
988: where pee.element_entry_id = c_element_entry_id
989: and pee.input_value_id = c_input_value_id
990: and (pee.effective_start_date between c_effective_start_date
991: and c_effective_end_date
1011: ) is
1012: select screen_entry_value
1013: ,effective_start_date
1014: ,effective_end_date
1015: from pay_element_entry_values_f pee
1016: where pee.element_entry_id = c_element_entry_id
1017: and pee.input_value_id = c_input_value_id
1018: and pee.effective_start_date = c_effective_start_date
1019: and pee.effective_end_date = c_effective_end_date;