하위조직 가지고 오기

AND NVL(EMP.ORG_CD_SET,EMP.ORG_CD) IN ( SELECT ORG_CD
                     FROM ORM_ORG_C
                    WHERE F_ORM_ORG_LINE(ORG_CD, '2', TRUNC(SYSDATE)) LIKE F_ORM_ORG_LINE(NVL(?, '100000') , '2', TRUNC(SYSDATE))||'%'
                      AND TRUNC(SYSDATE) BETWEEN STA_YMD AND END_YMD
                    )