[Home] [Help]
125: --
126: cursor csr_asg_sec is
127: select null
128: from per_pay_proposals pyp,
129: per_assignments_f2 asg
130: where pyp.pay_proposal_id = p_pay_proposal_id
131: and pyp.assignment_id = asg.assignment_id
132: and pyp.change_date between asg.effective_start_date
133: and asg.effective_end_date;