Monday, October 25, 2021

Query to get an Employees Leave History in Oracle APPS

 SELECT a.date_start,
         a.date_end,
         a.absence_days,
         (SELECT name
            FROM per_absence_attendance_types
           WHERE absence_attendance_type_id = a.absence_attendance_type_id
             AND business_group_id = a.business_group_id)
            leave_type
    FROM per_absence_attendances a
   WHERE person_id =
            (SELECT person_id
               FROM per_all_people_f
              WHERE employee_number = '1234567890'
                    AND employee_number IS NOT NULL)
ORDER BY date_start DESC

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...