BIP – Query to extract adjustment reasons attached on accrual Plan level
You can attach multiple adjustment reasons on accrual plan level. You can create any new custom adjustment reasons and add them in a lookup – ANC_ABS_PLAN_OTHER_REASONS.
Once the reason is added in the lookup, you can navigate to Absence Plans.
You can choose the newly added lookup code under “Enteries and Balances” tab.
Once the reasons are added, you can run below SQL query to extract the reasons added to the plan:
FROM ANC_ABSENCE_PLANS_F aapf
WHERE aapf.absence_plan_id = aapft.absence_plan_id
AND aapft.language = 'US'
AND TRUNC(SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_date
AND TRUNC(SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_date
AND aapf.other_reasons IS NOT NULL
AND aapf.other_reasons LIKE '%XX_MLA%'
ORDER BY 2,1