DBA Data[Home] [Help]

APPS.HR_DE_TAX_SUPPORT dependencies on HR_API

Line 333: select DECODE(P_TAX_CLASS,'NC',hr_api.g_varchar2,'DE_TAX_CLASS6')

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:

Line 334: ,DECODE(P_NO_OF_CHILDREN,'NC',hr_api.g_varchar2,'0')

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

Line 335: ,DECODE(P_TAX_FREE_INCOME,'NC',hr_api.g_varchar2,'0')

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

Line 336: ,DECODE(P_ADD_INCOME,'NC',hr_api.g_varchar2,'0')

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