Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
how do i pass HR assignement no to balance feed query
Summary
how do i pass HR assignement no to balance feed queryContent
Hi Members,
I need a help. There is an employee having two assignment no at the same legal entity. I need to calculate balance feed for one of the assignment only. i am using below query and can not pass specific HR assignment no here. How do i pass HR assignment in below query. Currently it is fetching balance for both assignment together. Appreciate for any help.
SELECT FND_NUMBER.CANONICAL_TO_NUMBER(prrv.result_value),pbff.scale
FROM PAY_PAY_RELATIONSHIPS_DN pprd
, PAY_PAYROLL_REL_ACTIONS ppra
0