Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need Help In Creating Table Type Value Set
Summary
Need Help In Creating Table Type Value SetContent
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')
Tagged:
1