Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_CA_EMP_ALL_PROVTAX_INFO_V |
SELECT PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, PCP.PROVINCE_CODE
, PCP.PROVINCE_ABBREV
, PCP.PROVINCE_NAME
, PCP.PROVINCE_ABBREV
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'NOTPROV')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'MARRIED')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'NONRES')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'DISABLE')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'NUMDEP')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'INFDEP')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'TCA')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'ADDTAX')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'PROVEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'PMEDEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'WCBEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'QPPEXEMPT')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'ANNDED')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'REMCOMM')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'EXPCOMM')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'PZDN')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'OVERRIDERATE')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'OVERRIDEAMNT')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'CALCMETHOD')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_DFS(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'STATINDIAN')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_DFS(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'OVER65')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_NUM(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'LSP')
, PAY_CA_EMP_TAX_INF.GET_PROV_TAX_DETAIL_CHAR(PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE
, PCP.PROVINCE_ABBREV
, 'PPIPEXEMPT')
FROM FND_SESSIONS FND
, PAY_CA_PROVINCES_V PCP
, PER_ASSIGNMENTS_F PAF
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE