[Home] [Help]
493: ,fin_oblig_end_date = p_lease_ext_end_dt
494: WHERE tenancy_id = rec.tenancy_id;
495:
496: IF l_lease_class_code <> 'DIRECT' THEN
497: UPDATE pn_space_assign_cust_all
498: SET cust_assign_end_date = p_lease_ext_end_dt
499: ,fin_oblig_end_date = p_lease_ext_end_dt
500: WHERE tenancy_id = rec.tenancy_id;
501: