536: hri_mds_wrkfc_mnth_ct wevt
537: ,hri_cs_geo_lochr_ct ctr
538: ,hri_cs_jobh_ct jobh
539: ,hri_cs_prsntyp_ct ptyp
540: ,(SELECT 'Y' sup_directs_only_flag FROM dual
541: UNION ALL
542: SELECT 'N' sup_directs_only_flag FROM dual
543: ) dcts
544: WHERE wevt.org_organztn_fk = p_organization_fk
538: ,hri_cs_jobh_ct jobh
539: ,hri_cs_prsntyp_ct ptyp
540: ,(SELECT 'Y' sup_directs_only_flag FROM dual
541: UNION ALL
542: SELECT 'N' sup_directs_only_flag FROM dual
543: ) dcts
544: WHERE wevt.org_organztn_fk = p_organization_fk
545: AND wevt.time_month_snp_fk = v_month_id
546: AND ctr.location_id = wevt.geo_location_fk