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


Sunday, 5 February 2017

Query to get employee Special Information

select papf.employee_number,
  ppt.user_person_type employee_type,
  -- version 2.09 changes --
  to_char(ppa.date_from,'dd-mon-yyyy') start_date,
  pac.segment1 "plan name",
  pac.segment2 "member id",
  pac.segment3 "plan id",
  pac.segment4 "exclusion code"
from per_all_people_f papf,
 per_all_assignments_f paaf,
  hr_soft_coding_keyflex hsck,
 per_person_analyses ppa,
  fnd_id_flex_structures fifs,
  per_special_info_types psit,
  per_analysis_criteria pac,
  per_person_types_tl ppt
where paaf.person_id            = papf.person_id
and ppt.person_type_id          = papf.person_type_id
and pac.id_flex_num             = fifs.id_flex_num
--and fifs.id_flex_structure_code = 'pera'
and ppt.person_type_id(+)       = papf.person_type_id
and psit.id_flex_num            = pac.id_flex_num
and ppa.person_id(+)            = papf.person_id
and pac.analysis_criteria_id(+) = ppa.analysis_criteria_id
and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id(+)
and paaf.assignment_type        = 'e'
and ppt.user_person_type       <> 'ex-employee'
  --     and papf.business_group_id = :p_business_group_id
and sysdate between papf.effective_start_date and papf.effective_end_date
and sysdate between paaf.effective_start_date and paaf.effective_end_date
--and papf.employee_number = '30987'
group by papf.full_name,
order by ppa.date_from desc;
Share this article :


  1. When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. small-business

  2. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. Employee Attendance

  3. One critical way in which facts era is affecting work is via reducing the importance of distance. in many industries, the geographic distribution of labor is changing drastically.TutuApp web

  4. Thank you for your submit. I will definitely comeback.

  5. This comment has been removed by the author.

  6. Today, it's basic for two-year-olds to utilize iPads, rudimentary schoolers snared to video games, and we as a whole endure (or live with) the test of prying your center schooler away from the PC sufficiently long to eat a good supper.Access Control System

  7. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it! vape attic olathe

  8. With a little startup information and tips anybody can effectively endeavor to assemble their own site. click for info

  9. it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity.. Copywriting Services

  10. My experience with both card and board games has changed as I've aged. As a child, I played Gin Rummy, 500 Rummy and Monopoly. In college, I learned to play Bridge which was a lot more challenging. When my children were small, I played Old Maid and simple board games. As a senior citizen, I play them all, but always with different friends or family members. And each game at each age has been different but (almost) always enjoyable.

  11. This article is an appealing wealth of informative data that is interesting and well-written. I commend your hard work on this and thank you for this information. You’ve got what it takes to get attention. Direct Response Copywriter