SELECT A.SETID, A.ITEM_TYPE, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFF_STATUS, A.DESCR, A.DESCRSHORT, A.CURRENCY_CD, A.MINIMUM_AMT, A.MAXIMUM_AMT, A.ITEM_TYPE_CD, A.SECURITY_GROUP, A.ADJUSTMENT_CAL_SF, A.PAYMENT_TERMS, A.PAYMENT_PRIORITY, A.CHARGE_PRIORITY, A.ENCUMBRANCE_DAYS, A.ENCUMBRANCE_PCT, A.SSF_STATE_FLAG, A.TENDER_SPEC, A.TENDER_CATEGORY, A.ALL_OR_NONE, A.ENROL_FLAG, A.KEYWORD1, A.KEYWORD2, A.KEYWORD3, A.DAYS_SINCE_EFFDT, A.DAYS_TO_EFFDT, A.DUEDAYS_PAST_EFFDT, A.DUEDAYS_PRIOR_EFFD, A.TERM_ENROLL_REQ, A.REFUNDABLE_IND, A.ERNCD, A.TAXABLE_Y_N, A.TUITION_DEPOSIT, A.GL_INTERFACE_REQ, A.DEFAULT_AMT, A.ERNCD_NOTAX, A.RECVABLE_FROM_CHRG, A.PRIORITY, A.PRIORITY_PMT_FLG, A.NRA_CREDIT_TAX_FLG, A.NRA_DEBIT_TAX_FLG, A.MATCH_WRITEOFF, A.LOCAL_TAX_OFFSET, A.LOCAL_TAX_PMT, A.STATE_TAX_OFFSET, A.STATE_TAX_PMT, A.GL_CRSE_CLASS_SPC, A.TAX_CD, A.T4_INCOME, A.WAGE_LOSS_PLAN, A.T2202A_FLG, A.T2202A_PCT, A.T2202A_OFFSET_FLG, A.PAY_PRIORITY_ID, A.ACCTG_DT_CNTL, A.SSF_ACCTG_DT_ID, A.SF_1098_FLG, A.SSF_DEST_TUT_TYPE, A.SFA_EA_TYPE, A.SFA_EA_SOURCE, A.SFA_EA_PROGRAM_CD, A.SSF_BILL_GBL_INV FROM PS_ITEM_TYPE_TBL A WHERE A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_ITEM_TYPE_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.ITEM_TYPE = A_ED.ITEM_TYPE AND A_ED.EFFDT <= SYSDATE) AND A.SETID = :1 | |||||||||||||||||||||