LOV is not working
Summary:
anc_per_abs_entries apae, per_periods_of_service pps, per_all_people_f per, anc_absence_types_vl abs |
---|
Value Col: abs.name |
ID COl: TO_CHAR(apae.per_absence_entry_id) |
Where apae.period_of_service_id = pps.period_of_service_id |
AND apae.absence_type_id = abs.absence_type_id |
AND pps.person_id = per.person_id |
AND TRUNC (SYSDATE) BETWEEN abs.effective_start_date |
AND abs.effective_end_date |
AND TRUNC (SYSDATE) BETWEEN per.effective_start_date |
AND per.effective_end_date |
AND apae.start_date >= |
TRUNC ( |
ADD_MONTHS (LAST_DAY (SYSDATE) + 1, |
EXTRACT (MONTH FROM SYSDATE) * -1)) |