LOV is not working — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!