[Home] [Help]
48: select pee.element_entry_id element_entry_id
49: ,pet.processing_type processing_type
50: ,pee.effective_start_date effective_start_date
51: ,pee.effective_end_date effective_end_date
52: from per_absence_attendances abs
53: ,per_all_assignments_f asg
54: ,pay_element_types_f pet
55: ,pay_element_links_f pel
56: ,pay_element_entries_f pee
80: select pee.element_entry_id element_entry_id
81: ,pet.processing_type processing_type
82: ,pee.effective_start_date effective_start_date
83: ,pee.effective_end_date effective_end_date
84: from per_absence_attendances abs
85: ,per_all_assignments_f asg
86: ,pay_element_types_f pet
87: ,pay_element_links_f pel
88: ,pay_element_entries_f pee
109: ,abs.person_id
110: ,abs.date_start
111: ,abs.date_end
112: ,abt.absence_category
113: FROM per_absence_attendances abs
114: ,per_absence_attendance_types abt
115: WHERE abs.absence_attendance_id = p_absence_attendance_id
116: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
117: --
511: -- Bug no 5020916. Order by clause included in the cursor
512: CURSOR csr_assignments(p_person_id NUMBER, p_effective_date DATE) IS
513: SELECT asg.assignment_id, asg.effective_start_date, asg.effective_end_date
514: FROM per_all_assignments_f asg,
515: per_absence_attendances paa
516: WHERE paa.absence_attendance_id = p_absence_attendance_id
517: and asg.person_id = paa.person_id
518: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
519: AND nvl(paa.date_end,asg.effective_start_date) >= asg.effective_start_date
733: ,abs.person_id
734: ,abs.date_start
735: ,abs.date_end
736: ,abt.absence_category
737: FROM per_absence_attendances abs
738: ,per_absence_attendance_types abt
739: WHERE abs.absence_attendance_id = p_absence_attendance_id
740: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
741:
831: ,abs.person_id
832: ,abs.date_start
833: ,abs.date_end
834: ,abt.absence_category
835: FROM per_absence_attendances abs
836: ,per_absence_attendance_types abt
837: WHERE abs.absence_attendance_id = p_absence_attendance_id
838: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
839:
903: select pee.element_entry_id element_entry_id
904: ,pet.processing_type processing_type
905: ,pee.effective_start_date effective_start_date
906: ,pee.effective_end_date effective_end_date
907: from per_absence_attendances abs
908: ,per_all_assignments_f asg
909: ,pay_element_types_f pet
910: ,pay_element_links_f pel
911: ,pay_element_entries_f pee
933: /* select pee.element_entry_id
934: ,pet.processing_type
935: ,pee.effective_start_date
936: ,pee.effective_end_date
937: from per_absence_attendances abs
938: ,per_all_assignments_f asg
939: ,pay_element_types_f pet
940: ,pay_element_links_f pel
941: ,pay_element_entries_f pee
1312: -- Bug no 5020916. Order by clause included in the cursor
1313: CURSOR csr_assignments(p_person_id NUMBER, p_effective_date DATE) IS
1314: SELECT asg.assignment_id, asg.effective_start_date, asg.effective_end_date
1315: FROM per_all_assignments_f asg,
1316: per_absence_attendances paa
1317: WHERE paa.absence_attendance_id = p_absence_attendance_id
1318: and asg.person_id = paa.person_id
1319: and paa.person_id = p_person_id
1320: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
1341: CURSOR csr_invalid_entries (p_element_type_id NUMBER) IS
1342: SELECT pee.element_entry_id, pee.effective_start_date
1343: FROM pay_element_entries_f pee,
1344: per_all_assignments_f asg1,
1345: per_absence_attendances paa1
1346: where pee.element_type_id = p_element_type_id
1347: AND paa1.absence_attendance_id = p_absence_attendance_id
1348: AND asg1.person_id = paa1.person_id
1349: AND asg1.assignment_id = pee.assignment_id --9971535
1350: AND pee.effective_start_date between asg1.effective_start_date AND asg1.effective_end_date --9971535
1351: AND asg1.assignment_id not in (
1352: SELECT asg.assignment_id
1353: FROM per_all_assignments_f asg,
1354: per_absence_attendances paa
1355: WHERE paa.absence_attendance_id = p_absence_attendance_id
1356: AND asg.person_id = paa.person_id
1357: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
1358: AND nvl(paa.date_end,asg.effective_start_date) >= asg.effective_start_date);
1363:
1364: cursor c_get_absence_details is
1365: select abs.person_id,
1366: abs.absence_attendance_type_id
1367: from per_absence_attendances abs
1368: where abs.absence_attendance_id = p_absence_attendance_id;
1369:
1370: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1371: l_processing_type VARCHAR2(30);
1711:
1712: CURSOR csr_assignments IS
1713: SELECT asg.assignment_id, asg.effective_start_date
1714: FROM per_all_assignments_f asg,
1715: per_absence_attendances paa
1716: WHERE paa.absence_attendance_id = p_absence_attendance_id
1717: and asg.person_id = paa.person_id
1718: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
1719: AND nvl(paa.date_end,asg.effective_start_date) >= asg.effective_start_date;
1723: select pee.element_entry_id element_entry_id
1724: ,pet.processing_type processing_type
1725: ,pee.effective_start_date effective_start_date
1726: ,pee.effective_end_date effective_end_date
1727: from per_absence_attendances abs
1728: ,per_all_assignments_f asg
1729: ,pay_element_types_f pet
1730: ,pay_element_links_f pel
1731: ,pay_element_entries_f pee
1757: /* select pee.element_entry_id element_entry_id
1758: ,pet.processing_type processing_type
1759: ,pee.effective_start_date effective_start_date
1760: ,pee.effective_end_date effective_end_date
1761: from per_absence_attendances abs
1762: ,per_all_assignments_f asg
1763: ,pay_element_types_f pet
1764: ,pay_element_links_f pel
1765: ,pay_element_entries_f pee