Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_CA_EMP_ALL_FEDTAX_INFO_V |
SELECT PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'EMPPROV')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'GEOCODE')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'TCA')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'ADDTAX')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'FEDEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'EIEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'PPEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'ANNDED')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'PZDN')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'REMCOMM')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'EXPCOMM')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'CALCMETHOD')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'OVERRIDERATE')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'OVERRIDEAMNT')
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_DFS(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'STATINDIAN' )
, PAY_CA_EMP_TAX_INF.GET_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, 'LSF')
FROM FND_SESSIONS FND
, PER_ASSIGNMENTS_F PAF
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE