This query fetches those leases which are going to expiry within 15,30,60,90,180 days respectively based on the parameter.  SELECT GCC....

Query to Fetch Leases which are expired but not terminated.  SELECT        GCC.segment4  SOL_ID       ,PLA.lease_id Lease_number    ...