598: --
599: CURSOR c_contract_type
600: IS
601: SELECT contract_type
602: FROM pqp_assignment_attributes_f
603: WHERE assignment_id = p_assignment_id
604: AND p_date BETWEEN effective_start_date AND effective_end_date;
605: BEGIN
606: --
916:
917: CURSOR csr_get_contract_type
918: IS
919: SELECT contract_type
920: FROM pqp_assignment_attributes_f
921: WHERE assignment_id = p_assignment_id
922: AND p_date BETWEEN effective_start_date
923: AND effective_end_date;
924: