APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 529: from per_absence_attendances paa, per_absence_attendance_types paat

525: cursor csr_absence_start_days (
526: p_person_id per_all_people_f.person_id%type
527: ) is
528: select paa.date_start, paa.date_end
529: from per_absence_attendances paa, per_absence_attendance_types paat
530: where paat.absence_attendance_type_id =
531: paa.absence_attendance_type_id
532: and paa.person_id = p_person_id
533: and paa.date_start between g_start_date and g_end_date

Line 558: ,per_absence_attendance_types paat

554: ,pay_user_columns puc
555: ,pay_user_columns_tl puct
556: ,pay_user_rows_f purf
557: ,pay_user_column_instances_f pucif
558: ,per_absence_attendance_types paat
559: ,per_abs_attendance_types_tl paatt
560: WHERE put.business_group_id = paa.business_group_id
561: AND put.user_table_id = putt.user_table_id
562: AND lower (trim (putt.user_table_name)) = lower (trim ('Norwegian Employers Employees Register Exclusion'))

Line 588: from per_absence_attendances paa, per_absence_attendance_types paat

584: p_person_id per_all_people_f.person_id%type
585: ,p_prev_last_date date
586: ) is
587: select paa.date_start, paa.date_end
588: from per_absence_attendances paa, per_absence_attendance_types paat
589: where paat.absence_attendance_type_id =
590: paa.absence_attendance_type_id
591: and paa.person_id = p_person_id
592: /* and paa.date_end - paa.date_start >= g_absence_termination_limit

Line 617: ,per_absence_attendance_types paat

613: ,pay_user_columns puc
614: ,pay_user_columns_tl puct
615: ,pay_user_rows_f purf
616: ,pay_user_column_instances_f pucif
617: ,per_absence_attendance_types paat
618: ,per_abs_attendance_types_tl paatt
619: WHERE put.business_group_id = paa.business_group_id
620: AND put.user_table_id = putt.user_table_id
621: AND lower (trim (putt.user_table_name)) = lower (trim ('Norwegian Employers Employees Register Exclusion'))