Learn about the new Oracle Fusion AI Agent Studio on April 15, 2025 at 8:00 am PT - Register Now
Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
Based on the parameter year i should get the data based on that year i should get the data.
lets say the paramter is audit_year = '31-12-2021'
the requirement is something that we should get the data based on the parameter i.e i should get the person record based on the above parmeter year.
for example lets assume that audit_year = '31-12-2022'
the person is inactive in 2022 so i should get that record only
if the audit_year = '31-12-2021' this person is active in that year so i should get that year only.
what i did is in the sql i gave as
trunc(:audit_year) between paam.effective_start_date and paam.effective_end_date
Tagged:
0