[Home] [Help]
261: p_start_date date,
262: p_business_group_id number
263: ) IS
264: SELECT MAX (effective_end_date) effective_date
265: FROM per_all_assignments_f paa
266: WHERE assignment_id = p_asg_id
267: AND paa.effective_start_date <= p_end_date
268: AND paa.effective_end_date > = p_start_date
269: AND assignment_status_type_id
384: lr_person_info csr_person_info%ROWTYPE;
385:
386: CURSOR csr_assignment_info (
387: csr_v_person_id per_all_people_f.person_id%TYPE
388: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
389: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
390: )
391: IS
392: SELECT *
385:
386: CURSOR csr_assignment_info (
387: csr_v_person_id per_all_people_f.person_id%TYPE
388: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
389: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
390: )
391: IS
392: SELECT *
393: FROM per_all_assignments_f p
389: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
390: )
391: IS
392: SELECT *
393: FROM per_all_assignments_f p
394: WHERE p.business_group_id = g_business_group_id
395: AND p.assignment_id = csr_v_assignment_id
396: AND p.person_id = csr_v_person_id
397: AND csr_v_effective_date BETWEEN p.effective_start_date
415: -- Cursor to extract the hourly pay variables in the Completion Working report
416:
417:
418: CURSOR csr_extra_assignment_info (
419: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
420: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
421: )
422: IS
423: SELECT *
428: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;
429:
430:
431: CURSOR csr_se_wtc_time_worked_info (
432: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
433: ,csr_v_year per_assignment_extra_info.aei_information2%TYPE
434: ,csr_v_month per_assignment_extra_info.aei_information3%TYPE
435: )
436: IS