[Home] [Help]
650: pn_locations_all loc,
651: pn_properties_all prop,
652: pn_index_leases_all ilease,
653: pn_var_rents_all var,
654: pn_payment_terms_all terms
655: WHERE lease.lease_id = p_lease_id
656: AND ten.primary_flag = 'Y'
657: AND ten.location_id = loc.location_id
658: AND ten.occupancy_date <= loc.active_start_date