APPS.PER_ABB_BUS dependencies on PER_ABSENCE_ATTENDANCES

Line 100: -- If updating, cannot be later than date_start of child row in PER_ABSENCE_ATTENDANCES

96: --
97: -- Description:
98: -- Validates that date_effective is supplied.
99: -- Must be earlier than date_end
100: -- If updating, cannot be later than date_start of child row in PER_ABSENCE_ATTENDANCES
101: --
102: -- Prerequisites:
103: --
104: -- In Arguments:

Line 134: from per_absence_attendances

130: l_api_updating boolean;
131: --
132: cursor csr_chk_attendance_date is
133: select 1
134: from per_absence_attendances
135: where absence_attendance_type_id = p_absence_attendance_type_id
136: and date_start < p_date_effective;
137: --
138: l_dummy number;

Line 720: -- per_absence_attendances

716: -- Description:
717: -- Validates absence_category
718: -- Must exist as enabled lookup_code for lookup_type 'ABSENCE_CATEGORY'
719: -- Value cannot be changed once it is not null if there is a chile record in
720: -- per_absence_attendances
721: --
722: -- Prerequisites:
723: --
724: --

Line 753: from per_absence_attendances

749: l_api_updating boolean;
750: --
751: cursor csr_absence_attendance is
752: select 1
753: from per_absence_attendances
754: where absence_attendance_type_id = p_absence_attendance_type_id;
755: --
756: l_dummy number;
757: --

Line 967: -- per_abs_attendance_reasons, per_absence_attendances

963: --
964: -- Description:
965: -- Checks if deletion of the absence type will be allowed.
966: -- Must be no records referencing absence type on the following tables.
967: -- per_abs_attendance_reasons, per_absence_attendances
968: --
969: -- Prerequisites:
970: --
971: -- In Arguments:

Line 993: from per_absence_attendances

989: l_dummy number;
990: --
991: cursor csr_attendance is
992: select 1
993: from per_absence_attendances
994: where absence_attendance_type_id = p_absence_attendance_type_id;
995: --
996: cursor csr_reason is
997: select 1