DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on PER_ABSENCE_ATTENDANCES

Line 100: FROM per_absence_attendances abs

96: -- ,l_start_time
97: -- ,l_end_time
98: ,l_days
99: ,l_hours
100: FROM per_absence_attendances abs
101: WHERE abs.absence_attendance_id = p_absence_attendance_id;
102: EXCEPTION
103: WHEN OTHERS THEN
104: NULL;

Line 139: FROM PER_ABSENCE_ATTENDANCES PAA

135: p_input_value6 := p_absence_attendance_id;
136:
137: SELECT fnd_number.canonical_to_number(PAA.ABS_INFORMATION3) INTO
138: l_absence_percentage
139: FROM PER_ABSENCE_ATTENDANCES PAA
140: WHERE PAA.ABSENCE_ATTENDANCE_ID =p_absence_attendance_id;
141:
142: p_input_value_name7 := 'Absence Percentage';
143: p_input_value7 := l_absence_percentage;

Line 325: FROM per_absence_attendances PAA,

321: PAA.absence_Hours,
322: PAA.TIME_START,
323: PAA.TIME_END,
324: PAA.ABS_INFORMATION3
325: FROM per_absence_attendances PAA,
326: per_absence_attendance_types PAAT
327: WHERE PAA.absence_attendance_id = p_absence_attendance_id
328: and PAA.ABSENCE_ATTENDANCE_TYPE_ID =PAAT.ABSENCE_ATTENDANCE_TYPE_ID ;
329: