MERGE INTO pws_crs_info n1
USING (SELECT /*+ DRIVING_SITE(ssbsect)*/
ssbsect_term_code, ssbsect_crse_numb,
ssbsect_subj_code, ssbsect_seq_numb,
ssbsect_crn, ssbsect_crse_title 
FROM ssbsect@PROD.US.ORACLE.COM,
scbcrse@PROD.US.ORACLE.COM, 
sobptrm@PROD.US.ORACLE.COM, 
stvsubj@PROD.US.ORACLE.COM, 
stvterm@PROD.US.ORACLE.COM
WHERE stvsubj_code = ssbsect_subj_code
AND scbcrse_subj_code = ssbsect_subj_code
AND scbcrse_crse_numb = ssbsect_crse_numb
AND scbcrse_eff_term = 
(SELECT MAX(scbcrse_eff_term) 
FROM saturn.scbcrse@PROD.US.ORACLE.COM x
WHERE x.scbcrse_eff_term <= ssbsect_term_code 
AND x.scbcrse_subj_code = ssbsect_subj_code 
AND x.scbcrse_crse_numb = ssbsect_crse_numb) 
AND sobptrm_term_code = ssbsect_term_code )) e1
ON ( pws_ssbsect_term_code = e1.ssbsect_term_code
AND n1.pws_ssbsect_crn = e1.ssbsect_crn )
WHEN MATCHED THEN UPDATE 
SET n1.pws_ssbsect_crse_numb = e1.ssbsect_crse_numb,
n1.pws_ssbsect_subj_code = e1.ssbsect_subj_code, 
n1.pws_ssbsect_sec_numb = e1.ssbsect_seq_numb,
n1.pws_ssbsect_crs_title = e1.ssbsect_crse_title
WHEN NOT MATCHED THEN 
INSERT ( pws_ssbsect_term_code, pws_ssbsect_crse_numb, 
pws_ssbsect_subj_code, pws_ssbsect_sec_numb,
pws_ssbsect_crn, pws_ssbsect_crs_title)
VALUES(e1.ssbsect_term_code, e1.ssbsect_crse_numb,
e1.ssbsect_subj_code, e1.ssbsect_seq_numb,
e1.ssbsect_crn, e1.ssbsect_crse_title,);