Line 693: between change_date and nvl(date_to, hr_general.end_of_time)
689: ,pay_element_types_f pet
690: where
691: ppp.assignment_id = p_assignment_id
692: and p_query_date 693: between change_date and nvl(date_to, hr_general.end_of_time) 694: and paa.assignment_id = ppp.assignment_id
695: and ppp.change_date
696: between paa.effective_start_date and paa.effective_end_date
697: and paa.pay_basis_id = ppb.pay_basis_id