75: and pspp.effective_start_date = l_effective_date;
76:
77: cursor csr_assignment is
78: select assignment_id,assignment_type, pay_basis_id
79: from per_all_assignments_f
80: where assignment_id = p_assignment_id and
81: l_effective_date between effective_start_date and effective_end_date;
82:
83: cursor csr_assignment_proc is
81: l_effective_date between effective_start_date and effective_end_date;
82:
83: cursor csr_assignment_proc is
84: select grade_id,grade_ladder_pgm_id,pay_basis_id
85: from per_all_assignments_f
86: where assignment_id = l_assignment_id and
87: l_effective_date between effective_start_date and effective_end_date;
88:
89: cursor csr_placement_db is