DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_ABSENCE_ATTENDANCES

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 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