2904:
2905: -- Get default date format
2906: CURSOR l_date_format_csr IS
2907: SELECT SYS_CONTEXT ('USERENV','NLS_DATE_FORMAT') 2908: FROM dual; 2909:
2910: -- Get contract end date
2911: CURSOR l_contract_csr (cp_contract_id NUMBER) IS
2912: SELECT end_date