SQL Text:
select vc.person_id
,vc.assignment_id
,to_char(peevf.effective_start_date,'mm/dd/yyyy') effective_date
,peef.effective_start_date
,petf.base_element_name icp_name
,peevf.screen_entry_value icp_amt
from cmp_vc_per_elig_plans vc
,pay_element_entries_f peef
,pay_element_types_f petf
,pay_input_values_vl pivf
,pay_element_entry_values_f peevf
,pay_entry_usages peu
,pay_payroll_assignments ppa
where 1 = 1
and peef.person_id = vc.person_id
and petf.element_type_id = vc.element_type_id
and petf.element_type_id = peef.element_type_id
and pivf.element_type_id = petf.element_type_id
and peevf.input_value_id = pivf.input_value_id
and peevf.element_entry_id = peef.element_entry_id
and pivf.name = 'Amount'
and vc.elig_flag = 'Y'
and vc.element_elig_flag = 'Y'
and peu.element_entry_id = peef.element_entry_id
and peu.payroll_relationship_id = ppa.payroll_relationship_id
and ppa.hr_assignment_id = vc.assignment_id
and peef.effective_start_date between :p_st_dt and :p_ed_dt
In this session we are going to see how to fetch Oracle Cloud Individual Compensation data using SQL.
Comments
Post a Comment