1104: from per_pay_proposals ppp
1105: , per_all_assignments_f asg
1106: , per_pay_bases ppb
1107: , pay_element_types_f pet 1108: , pay_input_values_f piv 1109: where ppp.assignment_id=p_assignment_id
1110: and asg.assignment_id=p_assignment_id
1111: and ppp.change_date between asg.effective_start_date and asg.effective_end_date
1112: and ppb.pay_basis_id=asg.pay_basis_id