|
SELECT DISTINCT A.TRC , A.DESCR FROM PS_TL_TRC_TBL A , PS_TL_ERNCD_TBL B ,ps_gp_abs_anly_gen c , ps_gp_abs_ernddmap d WHERE A.TRC = B.TRC AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = B.EFF_STATUS AND a.eff_status='A' AND b.effdt= ( SELECT MAX(ch.effdt) FROM PS_TL_ERNCD_TBL ch WHERE ch.trc= b.trc AND ch.pay_system=b.pay_system) AND d.abs_pay_system_cd='NA' AND d.effdt=( SELECT MAX(ch.effdt) FROM ps_gp_abs_ernddmap ch WHERE ch.abs_pay_system_cd=d.abs_pay_system_cd AND ch.pin_num=d.pin_num) AND b.erncd= d.erncd AND c.pin_num= d.pin_num
|
TRC