3078: -- Should not allow these PTO elements for CWKs
3079: select 'Y'
3080: from pay_element_links_f pel
3081: ,pay_element_types_f pet 3082: ,pay_accrual_plans pap 3083: where pel.element_link_id = p_element_link_id
3084: and p_session_date between pel.effective_start_date
3085: and pel.effective_end_date
3086: and pel.element_type_id = pet.element_type_id