[Home] [Help]
851: ) -- Check for snapshot data
852:
853: or (g_exclude_absence = 'No' -- Check absence existance only if it is not excluded
854: and exists (select 1 -- If an absence exists in the previous calander year
855: from per_absence_attendances abs
856: where abs.person_id = asg.person_id
857: and abs.business_group_id = asg.business_group_id
858: and (abs.date_end between g_cont_data_st_date and g_cont_data_end_date
859: or abs.date_start between g_cont_data_st_date and g_cont_data_end_date))
944: ) -- Check for snapshot data only
945:
946: or (g_exclude_absence = 'No' -- Check absence existance only if it is not excluded
947: and exists (select 1 -- If an absence exists in the previous calander year
948: from per_absence_attendances abs
949: where abs.person_id = asg.person_id
950: and abs.business_group_id = asg.business_group_id
951: and (abs.date_end between g_cont_data_st_date and g_cont_data_end_date
952: or abs.date_start between g_cont_data_st_date and g_cont_data_end_date))
2481: to_char(paat.absence_days,'fm999.0'),
2482: pcv.pcv_information5 absence_category,
2483: p_estab_no
2484: bulk collect into p_abs_tab
2485: from per_absence_attendances paat,
2486: per_absence_attendance_types paatt,
2487: pqp_configuration_values pcv
2488: where paat.absence_attendance_type_id = paatt.absence_attendance_type_id
2489: and paat.person_id = p_person_id
2511: to_char(paat.absence_days,'fm999.0'),
2512: pcv.pcv_information5 absence_type,
2513: p_estab_no
2514: bulk collect into p_abs_tab
2515: from per_absence_attendances paat,
2516: pqp_configuration_values pcv
2517: where paat.person_id = p_person_id
2518: and pcv.pcv_information_category = 'PQP_GB_SWF_ABSENCE_CODE'
2519: and pcv_information1 = 'ABSENCE_TYPE'
2539: to_char(paat.absence_days,'fm999.0'),
2540: pcv.pcv_information5 absence_reason,
2541: p_estab_no
2542: bulk collect into p_abs_tab
2543: from per_absence_attendances paat,
2544: per_abs_attendance_reasons paatr,
2545: pqp_configuration_values pcv
2546: where paatr.abs_attendance_reason_id = paat.abs_attendance_reason_id
2547: and paat.person_id = p_person_id