DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_EVT_ORGH dependencies on DUAL

Line 540: ,(SELECT 'Y' sup_directs_only_flag FROM dual

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

Line 542: SELECT 'N' sup_directs_only_flag FROM dual

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