329: l_update_mode := 'CORRECTION' ;
330: end if;
331:
332:
333: select DECODE(P_TAX_CLASS,'NC',hr_api.g_varchar2,'DE_TAX_CLASS6')
334: ,DECODE(P_NO_OF_CHILDREN,'NC',hr_api.g_varchar2,'0')
335: ,DECODE(P_TAX_FREE_INCOME,'NC',hr_api.g_varchar2,'0')
336: ,DECODE(P_ADD_INCOME,'NC',hr_api.g_varchar2,'0')
337:
330: end if;
331:
332:
333: select DECODE(P_TAX_CLASS,'NC',hr_api.g_varchar2,'DE_TAX_CLASS6')
334: ,DECODE(P_NO_OF_CHILDREN,'NC',hr_api.g_varchar2,'0')
335: ,DECODE(P_TAX_FREE_INCOME,'NC',hr_api.g_varchar2,'0')
336: ,DECODE(P_ADD_INCOME,'NC',hr_api.g_varchar2,'0')
337:
338: into l_tax_class
331:
332:
333: select DECODE(P_TAX_CLASS,'NC',hr_api.g_varchar2,'DE_TAX_CLASS6')
334: ,DECODE(P_NO_OF_CHILDREN,'NC',hr_api.g_varchar2,'0')
335: ,DECODE(P_TAX_FREE_INCOME,'NC',hr_api.g_varchar2,'0')
336: ,DECODE(P_ADD_INCOME,'NC',hr_api.g_varchar2,'0')
337:
338: into l_tax_class
339: ,l_no_of_children
332:
333: select DECODE(P_TAX_CLASS,'NC',hr_api.g_varchar2,'DE_TAX_CLASS6')
334: ,DECODE(P_NO_OF_CHILDREN,'NC',hr_api.g_varchar2,'0')
335: ,DECODE(P_TAX_FREE_INCOME,'NC',hr_api.g_varchar2,'0')
336: ,DECODE(P_ADD_INCOME,'NC',hr_api.g_varchar2,'0')
337:
338: into l_tax_class
339: ,l_no_of_children
340: ,l_tax_free_income