[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 not in (
1348: AND asg1.person_id = paa1.person_id
1349: AND asg1.assignment_id not in (
1350: SELECT asg.assignment_id
1351: FROM per_all_assignments_f asg,
1352: per_absence_attendances paa
1353: WHERE paa.absence_attendance_id = p_absence_attendance_id
1354: AND asg.person_id = paa.person_id
1355: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
1356: AND nvl(paa.date_end,asg.effective_start_date) >= asg.effective_start_date);
1361:
1362: cursor c_get_absence_details is
1363: select abs.person_id,
1364: abs.absence_attendance_type_id
1365: from per_absence_attendances abs
1366: where abs.absence_attendance_id = p_absence_attendance_id;
1367:
1368: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1369: l_processing_type VARCHAR2(30);
1703:
1704: CURSOR csr_assignments IS
1705: SELECT asg.assignment_id, asg.effective_start_date
1706: FROM per_all_assignments_f asg,
1707: per_absence_attendances paa
1708: WHERE paa.absence_attendance_id = p_absence_attendance_id
1709: and asg.person_id = paa.person_id
1710: AND nvl(paa.date_start,asg.effective_end_date) <= asg.effective_end_date
1711: AND nvl(paa.date_end,asg.effective_start_date) >= asg.effective_start_date;
1715: select pee.element_entry_id element_entry_id
1716: ,pet.processing_type processing_type
1717: ,pee.effective_start_date effective_start_date
1718: ,pee.effective_end_date effective_end_date
1719: from per_absence_attendances abs
1720: ,per_all_assignments_f asg
1721: ,pay_element_types_f pet
1722: ,pay_element_links_f pel
1723: ,pay_element_entries_f pee
1749: /* select pee.element_entry_id element_entry_id
1750: ,pet.processing_type processing_type
1751: ,pee.effective_start_date effective_start_date
1752: ,pee.effective_end_date effective_end_date
1753: from per_absence_attendances abs
1754: ,per_all_assignments_f asg
1755: ,pay_element_types_f pet
1756: ,pay_element_links_f pel
1757: ,pay_element_entries_f pee