[Home] [Help]
258: p_start_date date,
259: p_business_group_id number
260: ) IS
261: SELECT MAX (effective_end_date) effective_date
262: FROM per_all_assignments_f paa
263: WHERE assignment_id = p_asg_id
264: AND paa.effective_start_date <= p_end_date
265: AND paa.effective_end_date > = p_start_date
266: AND assignment_status_type_id
381: lr_person_info csr_person_info%ROWTYPE;
382:
383: CURSOR csr_assignment_info (
384: csr_v_person_id per_all_people_f.person_id%TYPE
385: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
386: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
387: )
388: IS
389: SELECT *
382:
383: CURSOR csr_assignment_info (
384: csr_v_person_id per_all_people_f.person_id%TYPE
385: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
386: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
387: )
388: IS
389: SELECT *
390: FROM per_all_assignments_f p
386: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
387: )
388: IS
389: SELECT *
390: FROM per_all_assignments_f p
391: WHERE p.business_group_id = g_business_group_id
392: AND p.assignment_id = csr_v_assignment_id
393: AND p.person_id = csr_v_person_id
394: AND csr_v_effective_date BETWEEN p.effective_start_date
412: -- Cursor to extract the hourly pay variables in the Completion Working report
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 *
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