Attachment 1881 Details for Bug 6377 – SS_0874_IMIS_Against call id - 6377

SS_0874_IMIS_Against call id - 6377

SS_0874_IMIS_Against call id - 6377.sql (text/plain), 1.15 KB, created by Sharad on 2021-04-26 15:04:45 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-04-26 15:04:45 IST

Size: 1.15 KB

patch

obsolete

>UPDATE EMPLOYEES A
>SET
>	(	EMPLOYEE_TYPE
>	,	EMPLOYEE_NAME
>	,	NAME_OF_FATHER
>	,	NAME_OF_MOTHER
>	,	EMAIL_ADDRESS
>	,	MOBILE_NO
>	,	DATE_OF_BIRTH
>	,	SEX
>	,	MARITAL_STATUS
>	,	NAME_OF_SPOUSE
>	,	BANK_ACCOUNT_NUMBER
>	,	PAN_NUMBER
>	,	DATE_OF_HIRING
>	,	DATE_OF_RETIREMENT
>	,	BANK_CODE
>	,	DEPARTMENT_CODE
>	,	SECTION_CODE
>	,	SUB_SECTION_CODE
>	,	DESIGNATION_CODE
>	,	EDUCATION_CODE
>	,	PREMISE_CODE
>	)
>	=
>	(
>	SELECT
>		STATUS_CODE
>	,	UPPER(EMPLOYEE_NAME)
>	,	FATHERS_NAME
>	,	MOTHERS_NAME
>	,	EMAIL_ID
>	,	MOBILE_NUMBER
>	,	DATE_OF_BIRTH
>	,	GENDER_CODE
>	,	DECODE(MARITAL_STATUS, 'M', 'Y', 'S', 'N', MARITAL_STATUS)
>	,	SPOUSE_NAME
>	,	BANK_AC_NMBR
>	,	PAN_NUMBER
>	,	DATE_OF_JOINING
>	,	DATE_OF_RETIREMENT
>	,	BANK_AC_CODE
>	,	DEPARTMENT_CODE
>	,	SECTION_CODE
>	,	SUB_SECTION_CODE
>	,	DESIGNATION_CODE
>	,	EDUCATION_LEVEL
>	,	LOCATION_CODE
>	FROM NEW_EMPLOYEES
>	WHERE OLD_EMP_CODE 	= A.EMPLOYEE_CODE
>	AND COMPANY_CODE 	= '78'
>	)
>WHERE EMPLOYEE_CODE = '21771';  
>
>
>UPDATE NEW_EMPLOYEES SET OLD_EMP_CODE = NULL
>WHERE EMPLOYEE_CODE =	'E21771'
>AND COMPANY_CODE 	= 	'17';
>
>DELETE FROM NEW_EMPLOYEES 
>WHERE EMPLOYEE_CODE =	'E21771'
>AND COMPANY_CODE 	= 	'17';

Actions: View

Attachments on bug 6377: 1881