DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on PER_ABS_ATTENDANCE_REASONS

Line 130: ,PER_ABS_ATTENDANCE_REASONS PAR

126: SELECT Meaning
127: INTO p_input_value5
128: FROM FND_LOOKUP_VALUES_VL LKP
129: ,PER_ABSENCE_ATTENDANCES PAA
130: ,PER_ABS_ATTENDANCE_REASONS PAR
131: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
132: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
133: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason
134: AND LKP.lookup_type = 'ABSENCE_REASON'

Line 162: ,PER_ABS_ATTENDANCE_REASONS PAR

158: SELECT Meaning
159: INTO p_input_value5
160: FROM FND_LOOKUP_VALUES_VL LKP
161: ,PER_ABSENCE_ATTENDANCES PAA
162: ,PER_ABS_ATTENDANCE_REASONS PAR
163: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
164: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
165: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason
166: AND LKP.lookup_type = 'ABSENCE_REASON'