하위조직 가지고 오기

Posted by MD워시퍼
2010. 1. 18. 17:20 Study
728x90
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
                    )