[Home] [Help]
514: cursor csr_absence_days (
515: p_person_id per_all_people_f.person_id%type
516: ) is
517: select paa.date_start, paa.date_end
518: from per_absence_attendances paa, per_absence_attendance_types paat
519: where paat.absence_attendance_type_id =
520: paa.absence_attendance_type_id
521: and paa.person_id = p_person_id
522: and paa.date_end - paa.date_start > g_absence_termination_limit
530: cursor csr_absence_start_days (
531: p_person_id per_all_people_f.person_id%type
532: ) is
533: select paa.date_start, paa.date_end
534: from per_absence_attendances paa, per_absence_attendance_types paat
535: where paat.absence_attendance_type_id =
536: paa.absence_attendance_type_id
537: and paa.person_id = p_person_id
538: and paa.date_start between g_effective_start_date and g_effective_date
558: ,pay_user_columns puc
559: ,pay_user_columns_tl puct
560: ,pay_user_rows_f purf
561: ,pay_user_column_instances_f pucif
562: ,per_absence_attendance_types paat
563: ,per_abs_attendance_types_tl paatt
564: WHERE put.business_group_id = paa.business_group_id
565: AND put.user_table_id = putt.user_table_id
566: AND lower (trim (putt.user_table_name)) = lower (trim ('Norwegian Employers Employees Register Exclusion'))
591: p_person_id per_all_people_f.person_id%type
592: ,p_prev_last_date date
593: ) is
594: select paa.date_start, paa.date_end
595: from per_absence_attendances paa, per_absence_attendance_types paat
596: where paat.absence_attendance_type_id =
597: paa.absence_attendance_type_id
598: and paa.person_id = p_person_id
599: and paa.date_end between p_prev_last_date and g_effective_date
620: ,pay_user_columns puc
621: ,pay_user_columns_tl puct
622: ,pay_user_rows_f purf
623: ,pay_user_column_instances_f pucif
624: ,per_absence_attendance_types paat
625: ,per_abs_attendance_types_tl paatt
626: WHERE put.business_group_id = paa.business_group_id
627: AND put.user_table_id = putt.user_table_id
628: AND lower (trim (putt.user_table_name)) = lower (trim ('Norwegian Employers Employees Register Exclusion'))