5130: ;
5131: CURSOR c_pay_basis IS
5132: select ppb.pay_annualization_factor
5133: from per_all_assignments_f asg
5134: ,per_pay_bases ppb
5135: where asg.assignment_id = p_assignment_id
5136: and p_effective_date between asg.effective_start_date
5137: and asg.effective_end_date
5138: and ppb.pay_basis_id = asg.pay_basis_id
5216: ;
5217: CURSOR c_pay_basis IS
5218: select ppb.pay_annualization_factor
5219: from per_all_assignments_f asg
5220: ,per_pay_bases ppb
5221: where asg.assignment_id = p_assignment_id
5222: and p_effective_date between asg.effective_start_date
5223: and asg.effective_end_date
5224: and ppb.pay_basis_id = asg.pay_basis_id