413:
414:
415: CURSOR csr_extra_assignment_info (
416: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
417: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
418: )
419: IS
420: SELECT *
421: FROM per_assignment_extra_info
417: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
418: )
419: IS
420: SELECT *
421: FROM per_assignment_extra_info
422: WHERE assignment_id = csr_v_assignment_id
423: AND information_type = csr_v_information_type;
424:
425: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;
426:
427:
428: CURSOR csr_se_wtc_time_worked_info (
429: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
430: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE
431: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
432: )
433: IS
434: SELECT *
427:
428: CURSOR csr_se_wtc_time_worked_info (
429: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
430: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE
431: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
432: )
433: IS
434: SELECT *
435: FROM per_assignment_extra_info
431: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
432: )
433: IS
434: SELECT *
435: FROM per_assignment_extra_info
436: WHERE assignment_id = csr_v_assignment_id
437: AND information_type = 'SE_WTC_TIME_WORKED_INFO'
438: AND aei_information1 = csr_v_year
439: AND aei_information2 = csr_v_month;