[Home] [Help]
2939: ,pivO.element_type_id OBS_element_id
2940: ,pivA.element_type_id ADJ_element_id
2941: ,pap.business_group_id business_Group_id
2942: from pay_accrual_plans pap
2943: ,per_absence_attendances paa
2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
3768: ,sum(to_number(nvl(paa.abs_information3,'0'))) /* protected days booked */
3769: ,sum(to_number(nvl(paa.abs_information4,'0'))) /* conventional days booked */
3770: ,sum(to_number(nvl(paa.abs_information5,'0'))) /* Seniority days booked */
3771: ,sum(to_number(nvl(paa.abs_information6,'0'))) /* Young mothers days booked */
3772: from per_absence_attendances paa
3773: ,pay_element_entries_f pee
3774: where pee.element_link_id in (select element_link_id
3775: from pay_element_links_f
3776: where element_type_id = p_holiday_element_id
4409:
4410: /* fetch from before the absence started */
4411: cursor csr_start_date is
4412: select date_start - 366
4413: from per_absence_attendances
4414: where absence_attendance_id = p_absence_attendance_id;
4415:
4416: BEGIN
4417:
4606: ,pivO.element_type_id OBS_element_id
4607: ,pivA.element_type_id ADJ_element_id
4608: ,pap.business_group_id business_Group_id
4609: from pay_accrual_plans pap
4610: ,per_absence_attendances paa
4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4832: ,abs.abs_information5 /* conventional days */
4833: ,abs.abs_information6 /* protected days */
4834: ,pee.assignment_id
4835: from pay_element_entries_f pee
4836: ,per_absence_attendances abs
4837: where pee.element_entry_id = c_element_entry_id
4838: and pee.creator_id = abs.absence_attendance_id;
4839: --
4840: CURSOR csr_session_date is
5812: ,p_start_date Date, p_end_date Date) is
5813: -- Added the following cursor for cheking whether the employee
5814: -- has taken a sick leave between LDW and ATD. Bug#2874154
5815: select 1
5816: from per_absence_attendances paa
5817: ,pay_element_entries_f pee
5818: ,per_absence_attendance_types pat
5819: where pee.creator_type = 'A'
5820: and paa.absence_attendance_id = pee.creator_id
5826: --Changed the following cursor for bug#3030610.
5827: CURSOR csr_booked_holiday (p_assignment_id in number, p_holiday_element_id in number
5828: ,p_start_date Date, p_end_date Date) is
5829: select NVL(sum(paa.abs_information2), -1)
5830: from per_absence_attendances paa
5831: ,pay_element_entries_f pee
5832: where pee.element_link_id in (select element_link_id
5833: from pay_element_links_f
5834: where element_type_id = p_holiday_Element_id
5909:
5910: CURSOR csr_booked_holiday (p_assignment_id in number, p_holiday_element_id in number
5911: ,p_start_date Date, p_end_date Date, p_no_absences in number) is
5912: select 1
5913: from per_absence_attendances paa
5914: ,pay_element_entries_f pee
5915: where pee.element_link_id in (select element_link_id
5916: from pay_element_links_f
5917: where element_type_id = p_holiday_element_id
6018: --
6019: -- Cursor to sum up existing absences against entitled holidays
6020: Cursor csr_exist_abs(p_hire_date date) is
6021: Select sum(date_end-date_start+1)
6022: from per_absence_attendances
6023: where person_id = p_person_id
6024: and date_end <= p_abs_date_end
6025: and date_start >= p_hire_date
6026: and absence_attendance_type_id = p_absence_attendance_type_id;