APPS.PAY_CA_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 588: from per_absence_attendances_v paav

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

Line 1034: from per_absence_attendances abs

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

Line 1714: from per_absence_attendances abs

1710:
1711: cursor cur_abs ( b_person_id number,
1712: b_date_start date) is
1713: select abs.date_end date_end
1714: from per_absence_attendances abs
1715: where abs.person_id = b_person_id
1716: and abs.date_start = b_date_start;
1717:
1718: cursor cur_archive_info is