Query to fetch Public Holiday on basis of Location

SELECT hla.location_id,
       hla.location_name,
       hla.internal_location_code,
       pcet.NAME,
       pce.short_code,
       pcet.description,
       pce.category,
       pce.coverage_type,
       pce.start_date_time,
       pce.end_date_time,
       pce.tree_code,
       pce.tree_structure_code,
       pcec.last_updated_by,
       pcec.last_update_date
FROM   hr_locations_all hla,
       per_calendar_events pce,
       per_calendar_events_tl pcet,
       per_cal_event_coverage pcec,
       per_geo_tree_node_rf pgtnr
WHERE  hla.geo_hierarchy_node_value = pgtnr.ancestor_pk1_value
       AND pgtnr.tree_structure_code = 'PER_GEO_TREE_STRUCTURE'
       AND pgtnr.distance IN ( 0 )
       AND pgtnr.ancestor_tree_node_id = pcec.tree_node_id
       AND pcec.calendar_event_id = pcet.calendar_event_id
       AND pcet.calendar_event_id = pce.calendar_event_id
       AND pcet.language = USERENV('lang')
       AND pcec.coverage_flag IN ( 'I' )
       AND TRUNC(sysdate) BETWEEN hla.effective_start_date AND
                                  hla.effective_end_date
       AND hla.location_name = 'Mumbai'