VIEW: APPS.IGS_SV_EDT_OFF_EMPL_BLK_V

Source

View Text - Preformatted

SELECT emp_new.batch_id, emp_new.person_id, emp_new.print_form, emp_new.EMPL_START_DATE NEW_EMPL_START_DATE, emp_new.EMPL_END_DATE NEW_EMPL_END_DATE, emp_new.empl_type NEW_EMPLOYMENT_TYPE, emp_new.remarks recommendation, emp_new.recommend_empl recommend_employment, emp_old.EMPL_START_DATE, emp_old.EMPL_END_DATE, emp_old.empl_type employment_type FROM igs_sv_empl_info emp_new, igs_sv_empl_info emp_old WHERE emp_new.empl_rec_type = 'F' AND emp_new.action_code = 'E' AND emp_new.person_id = emp_old.person_id and emp_old.empl_rec_type = 'F' AND emp_new.batch_id <> emp_old.batch_id and emp_old.batch_id = (select max(batch_id) from igs_sv_empl_info where person_id = emp_new.person_id and nonimg_empl_id = emp_new.nonimg_empl_id AND batch_id < (select max(batch_id) from igs_sv_empl_info where person_id = emp_new.person_id and nonimg_empl_id = emp_new.nonimg_empl_id) )

View Text - HTML Formatted

SELECT EMP_NEW.BATCH_ID
, EMP_NEW.PERSON_ID
, EMP_NEW.PRINT_FORM
, EMP_NEW.EMPL_START_DATE NEW_EMPL_START_DATE
, EMP_NEW.EMPL_END_DATE NEW_EMPL_END_DATE
, EMP_NEW.EMPL_TYPE NEW_EMPLOYMENT_TYPE
, EMP_NEW.REMARKS RECOMMENDATION
, EMP_NEW.RECOMMEND_EMPL RECOMMEND_EMPLOYMENT
, EMP_OLD.EMPL_START_DATE
, EMP_OLD.EMPL_END_DATE
, EMP_OLD.EMPL_TYPE EMPLOYMENT_TYPE
FROM IGS_SV_EMPL_INFO EMP_NEW
, IGS_SV_EMPL_INFO EMP_OLD
WHERE EMP_NEW.EMPL_REC_TYPE = 'F'
AND EMP_NEW.ACTION_CODE = 'E'
AND EMP_NEW.PERSON_ID = EMP_OLD.PERSON_ID
AND EMP_OLD.EMPL_REC_TYPE = 'F'
AND EMP_NEW.BATCH_ID <> EMP_OLD.BATCH_ID
AND EMP_OLD.BATCH_ID = (SELECT MAX(BATCH_ID)
FROM IGS_SV_EMPL_INFO
WHERE PERSON_ID = EMP_NEW.PERSON_ID
AND NONIMG_EMPL_ID = EMP_NEW.NONIMG_EMPL_ID
AND BATCH_ID < (SELECT MAX(BATCH_ID)
FROM IGS_SV_EMPL_INFO
WHERE PERSON_ID = EMP_NEW.PERSON_ID
AND NONIMG_EMPL_ID = EMP_NEW.NONIMG_EMPL_ID) )