APPS.PAY_CA_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 584: from per_absence_attendances_v paav

580: select paav.date_start date_start,
581: paav.date_end recall_date,
582: paav.abs_information1 roe_reason,
583: paav.abs_information2 roe_comment
584: from per_absence_attendances_v paav
585: where paav.person_id=p_person_id
586: and paav.business_group_id = p_business_group_id
587: and paav.date_start <= cp_effective_date
588: and p_effective_date - paav.date_start <= 31;

Line 1030: from per_absence_attendances abs

1026:
1027: cursor cur_abs ( b_person_id number,
1028: b_date_start date) is
1029: select abs.date_end date_end
1030: from per_absence_attendances abs
1031: where abs.person_id = b_person_id
1032: and abs.date_start = b_date_start;
1033:
1034: /* FUNCTION last_period_of_service (p_effective_date date,

Line 1710: from per_absence_attendances abs

1706:
1707: cursor cur_abs ( b_person_id number,
1708: b_date_start date) is
1709: select abs.date_end date_end
1710: from per_absence_attendances abs
1711: where abs.person_id = b_person_id
1712: and abs.date_start = b_date_start;
1713:
1714: cursor cur_archive_info is