DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE_USER dependencies on PER_ABSENCE_ATTENDANCES

Line 64: FROM per_absence_attendances paa, per_absence_attendance_types pat

60: CURSOR CSR_CONT_LINK (l_person_id IN number,l_abs_st_date IN date) IS
61: SELECT paa.absence_attendance_id
62: ,paa.date_start
63: ,paa.date_end
64: FROM per_absence_attendances paa, per_absence_attendance_types pat
65: WHERE paa.person_id = l_person_id
66: AND paa.date_start < l_abs_st_date
67: AND paa.date_end < l_abs_st_date
68: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 113: FROM per_absence_attendances abs

109: ,l_start_time
110: ,l_end_time
111: ,l_intial_absence
112: ,l_initial_abs_creator_id
113: FROM per_absence_attendances abs
114: WHERE abs.absence_attendance_id = p_absence_attendance_id;
115: EXCEPTION
116: WHEN OTHERS THEN
117: NULL;