SELECT tblempview.empobjid            AS empobjid,
       tblempview.lastname            AS lastname,
       tblempview.firstname           AS firstname,
       tblempview.jobfunction         AS jobfunction,
       tblempview.bizcalhdr           AS bizcalhdrobjid,
       tblempview.empmaxtravradius    AS empmaxtravradius,
       tblempview.repsite_objid       AS repsiteobjid,
       tblempview.repsite_name        AS repsitename,
       tblempview.repsite_region      AS repsiteregion,
       tblempview.repsite_district    AS repsitedistrict,
       tblempview.repsite_city        AS repsitecity,
       tblempview.repsite_state       AS repsitestate,
       tblempview.repsite_lat         AS repsitelat,
       tblempview.repsite_long        AS repsitelong,
       tblempview.repsite_holiday_grp AS repsiteholidaygrp,
       tblempview.physsite_objid      AS physsiteobjid,
       tblempview.physsite_name       AS physsitename,
       tblempview.physsite_region     AS physsiteregion,
       tblempview.physsite_district   AS physsitedistrict,
       tblempview.physsite_lat        AS physsitelat,
       tblempview.physsite_long       AS physsitelong,
       tz.gmt_diff,
       tz.full_name,
       dst.start_time                 AS dststarttime,
       dst.end_time                   AS dstendtime,
       country.NAME                   AS countryname,
       penalty.x_map_from             AS beforeotmins,
       penalty.x_map_to               AS afterotmins
FROM   ora_emp_loc_view tblempview,
       table_user usr,
       table_site physsite,
       table_address addr,
       table_country country,
       table_time_zone tz,
       table_daylight_hr dst,
       table_x_gsa_penalty_map penalty
WHERE  tblempview.fieldeng = 1
       AND tblempview.usrobjid = usr.objid
       AND usr.status = 1
       AND tblempview.physsite_objid = physsite.objid
       AND physsite.cust_primaddr2address = addr.objid
       AND addr.address2country = country.objid
       AND addr .address2time_zone = tz.objid
       AND tblempview.otdefobjid = penalty.objid(+)
       AND tz.objid = dst.daylight_hr2time_zone(+)
       AND dst.start_time(+) <= :1
       AND dst.end_time(+) >= :2  

select count(*) from table_user;
select count(*) from table_user usr where usr.status=1;