SELECT prgms.batch_id, prgms.person_id, prgms.print_form, prgms.prgm_start_date new_prgm_start_date, prgms.prgm_end_date new_prgm_end_date, prgms.remarks da_remarks FROM igs_sv_prgms_info prgms WHERE prgms.prgm_action_type = 'D'
SELECT PRGMS.BATCH_ID
, PRGMS.PERSON_ID
, PRGMS.PRINT_FORM
, PRGMS.PRGM_START_DATE NEW_PRGM_START_DATE
, PRGMS.PRGM_END_DATE NEW_PRGM_END_DATE
, PRGMS.REMARKS DA_REMARKS
FROM IGS_SV_PRGMS_INFO PRGMS
WHERE PRGMS.PRGM_ACTION_TYPE = 'D'
|
|
|