About Me

Dubai, United Arab Emirates
My name is Muhammad Faizan Karim and my aim is to spread the knowledge to everyone who want to learn oracle HRMS. I will try to write the video blogs for beginners so they can understand e-business suits from HRMS perspective, and if you have any difficulty in oracle applications HRMS , please feel free to contact with me at this email : faizan.kareem.ocp@gmail.com
Powered by Blogger.
Tuesday, December 25, 2018

Query to Get Element Retro Details from Element Definition

12:19 AM | Posted by | Edit Post
SELECT petf.element_type_id,
       petf.element_name,
       peg.event_group_name,
       prcu.retro_component_usage_id,
       pesu.retro_element_type_id,
       petf_retro.element_name retro_element_name
  FROM pay_element_types_f petf,
       pay_event_groups peg,
       pay_retro_component_usages prcu,
       pay_element_span_usages pesu,
       pay_element_types_f petf_retro
 WHERE     1=1
       AND petf.recalc_event_group_id = peg.event_group_id
       AND prcu.creator_id = petf.element_type_id
       AND pesu.retro_component_usage_id = prcu.retro_component_usage_id
       AND petf_retro.element_type_id = pesu.retro_element_type_id

0 comments:

Post a Comment
Subscribe to: Post Comments (Atom)

Designed by Muhammad Faizan.