SELECT A.EMPLID , C.EXPEND_MTHD , A.CRDMEM_ACCT_NBR , A.CREDIT_CARD_VENDOR , B.DESCR , A.EXPIRATION_DT FROM PS_CC_CARD_DATA_EX A , PS_CC_CARD_TBL_EX B , PS_EX_EXP_MTHD_TBL C WHERE A.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'CC_CARD_TBL_EX') AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'EX_EXP_MTHD_TBL') AND B.VENDOR_SETID = C.VENDOR_SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.EXPEND_MTHD_EDIT = 'VND' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_CC_CARD_TBL_EX B1 WHERE B1.SETID = B.SETID AND B1.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_EX_EXP_MTHD_TBL C1 WHERE C1.SETID = C.SETID AND C1.EXPEND_MTHD = C.EXPEND_MTHD AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'
|