[Home] [Help]
2017: CURSOR sch_detail_c IS
2018: SELECT authorization_code AUTHORIZATION_CODE,
2019: cutoff_date CUTOFF_DATE,
2020: schedule_quantity SCHEDULE_QUANTITY
2021: FROM chv_authorizations
2022: WHERE reference_id = rec_item.schedule_item_id
2023: AND reference_type = 'SCHEDULE_ITEMS';
2024:
2025: BEGIN -- begin item detail block