Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 11 May 2016

Query To Get Employee Address Details

SELECT   ppt.user_person_type person_type, papf.full_name employee_name,
         papf.employee_number employee_number, pa.address_line1,
         pa.address_line2, pa.address_line3, pa.town_or_city, pa.postal_code,
         pa.country
    FROM per_all_people_f papf,
         per_all_assignments_f paaf,
         per_addresses pa,
         per_person_types_tl ppt
   WHERE papf.person_id = paaf.person_id
     AND paaf.primary_flag = 'Y'
     --AND PAPF.EMPLOYEE_NUMBER = '30987'
     AND papf.current_employee_flag = 'Y'
     AND papf.business_group_id = paaf.business_group_id
     AND paaf.person_id = pa.person_id
     AND papf.person_type_id = ppt.person_type_id
     AND TRUNC (SYSDATE) BETWEEN pa.date_from
                             AND NVL (pa.date_to, TRUNC (SYSDATE) + 1)
     AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                             AND papf.effective_end_date
     AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date
                             AND paaf.effective_end_date
--   AND PAPF.FULL_NAME LIKE 'A%'

ORDER BY papf.full_name;
Share this article :

0 comments:

Post a Comment