Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
SELECT tr_job_chg_id, emplid, action_dt_ss, EFFSEQ, TR_OFF_TITL_CHG FROM ps_tr_job_chg_tbl A WHERE A.TR_OFF_TITL_CHG <> 'Y' and a.TR_JOB_CHG_ACTION ='U' AND (a.emplid, a.action_dt_ss, a.effseq) in (select b.emplid , b.effdt, b.effseq from ps_job b where a.emplid = b.emplid and a.action_dt_ss = b.effdt and a.effseq = b.effseq and b.ELIG_CONFIG4 = ' ') and exists (SELECT emplid, effdt, EFFSEQ, ELIG_CONFIG4 FROM PS_JOB C WHERE C.emplid = a.emplid AND C.ELIG_CONFIG4 <> ' ' AND c.effdt = (SELECT MAX(ED.EFFDT) FROM PS_JOB ED WHERE ED.EMPLID = c.EMPLID AND ED.EMPL_RCD = c.EMPL_RCD AND ED.EFFDT < a.action_dt_ss) AND c.EFFSEQ = (SELECT MAX(ES.EFFSEQ) FROM PS_JOB ES WHERE ES.EMPLID = c.EMPLID AND ES.EMPL_RCD = c.EMPL_RCD AND ES.EFFDT = c.EFFDT))
|How to View Errors for Materialized Views in Oracle SQL Developer||2||53|
|Oracle - running a packate routine(function) - Testing in a cursor and comparing old and new||7||35|
|Getting network error using utl tcp package||7||58|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!