VIEW: APPS.PAY_CA_EMP_ALL_FEDTAX_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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