You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Need Help In Creating Table Type Value Set

edited Jul 25, 2020 2:12PM in Human Capital Management 2 comments

Summary

Need Help In Creating Table Type Value Set

Content

Hi Experts,

 

Wondering whether a Table Type Value Set be created with below base SQL:

 

select sum(TO_NUMBER(nvl(apecd1.value,0)))

from anc_per_acrl_entry_dtls apecd1,anc_absence_plans_f_tl aapft1,per_all_people_f papf1

where   apecd1.pl_id = aapft1.absence_plan_id

and     apecd1.person_id = papf1.person_id

and     aapft1.language = 'US'

and     trunc(sysdate) between aapft1.effective_start_date and aapft1.effective_end_date

and     trunc(sysdate) between papf1.effective_start_date and papf1.effective_end_date

and     TO_DATE(apecd1.procd_date,'YYYY-MM-DD') >  TO_DATE('2020-04-01','YYYY-MM-DD')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!