eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_TAX_DECL_REPORT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12


            SELECT payroll_action_id
              INTO l_payroll_action_id
              FROM pay_payroll_actions ppa,
                   fnd_conc_req_summary_v fcrs,
                   fnd_conc_req_summary_v fcrs1
             WHERE fcrs.request_id = fnd_global.conc_request_id
               AND fcrs.priority_request_id = fcrs1.priority_request_id
               AND ppa.request_id BETWEEN fcrs1.request_id
                                      AND fcrs.request_id
               AND ppa.request_id = fcrs1.request_id;

Line: 62


	SELECT mod(l_amount,10) INTO l_digit(l_count) from dual;

Line: 67


   SELECT floor(l_amount) INTO l_digit(l_count) from dual;

Line: 129


SELECT pai.action_information3 Organization_Name,
pai.action_information4 Month,
pai.action_information5 Year,
pai.action_information8 Declaration_Due_Date,
pai.action_information6 Administrative_Code,
pai.action_information7 Information,
pai1.action_information3 Organization_Number,
fnd_number.canonical_to_number(pai1.action_information4) Reduction,
fnd_number.canonical_to_number(pai1.action_information7) Code,
fnd_number.canonical_to_number(pai1.action_information8) Canada,
fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
-- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support,      -- EOY 2008
-- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5,    -- EOY 2008
fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
fnd_number.canonical_to_number(pai1.action_information14) Pension,
fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
fnd_number.canonical_to_number(pai1.action_information16) Interest,
fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
pai1.action_information18 Contact,
pai1.action_information19 Phone,
fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances,       --EOY 2008
fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29,    --EOY 2008
fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
fnd_number.canonical_to_number(pai2.action_information4) Benefit,
fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below,     -- EOY 2008
fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below   -- EOY 2008
FROM
pay_action_information pai,
pay_payroll_actions ppa,
pay_action_information pai1,
pay_action_information pai2
WHERE
pai.action_context_id = ppa.payroll_action_id
AND ppa.payroll_action_id =csr_v_pa_id
AND pai.action_context_id = pai1.action_context_id
AND pai1.action_context_id= pai2.action_context_id
AND pai2.action_context_id=pai1.action_context_id
AND pai1.action_context_type='PA'
AND pai1.action_information2 = 'INF'
AND pai1.action_information1 = 'PYSETADA'
AND pai1.action_information_category = 'EMEA REPORT INFORMATION'
AND pai.action_context_type = 'PA'
AND pai.action_information1 = 'PYSETADA'
AND pai.action_information_category = 'EMEA REPORT DETAILS'
AND pai2.action_context_type = 'PA'
AND pai2.action_information1 = 'PYSETADA'
AND pai2.action_information_category = 'EMEA REPORT INFORMATION'
AND pai2.action_information2 = 'BAL';

Line: 199


SELECT nvl(fnd_number.canonical_to_number(global_value),0) FROM ff_globals_f WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
	and csr_v_effective_date --p_effective_date
	BETWEEN effective_start_date AND
	effective_end_date;

Line: 1791


SELECT pai.action_information3 Organization_Name,
pai.action_information4 Month,
pai.action_information5 Year,
pai.action_information8 Declaration_Due_Date,
pai.action_information6 Administrative_Code,
pai.action_information7 Information,
pai1.action_information3 Organization_Number,
fnd_number.canonical_to_number(pai1.action_information4) Reduction,
pai1.action_information7 Code,
fnd_number.canonical_to_number(pai1.action_information8) Canada,
fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
-- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support,  -- EOY 2008
-- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5,  -- EOY 2008
fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
fnd_number.canonical_to_number(pai1.action_information14) Pension,
fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
fnd_number.canonical_to_number(pai1.action_information16) Interest,
fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
pai1.action_information18 Contact,
pai1.action_information19 Phone,
fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances,    --EOY 2008
fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
fnd_number.canonical_to_number(pai2.action_information4) Benefit,
fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below,     -- EOY 2008
fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below   -- EOY 2008
FROM
pay_action_information pai,
pay_payroll_actions ppa,
pay_action_information pai1,
pay_action_information pai2
WHERE
pai.action_context_id = ppa.payroll_action_id
AND ppa.payroll_action_id =csr_v_pa_id
AND pai.action_context_id = pai1.action_context_id
AND pai1.action_context_id= pai2.action_context_id
AND pai2.action_context_id=pai1.action_context_id
AND pai1.action_context_type='PA'
AND pai1.action_information2 = 'INF'
AND pai1.action_information1 = 'PYSETADA'
AND pai1.action_information_category = 'EMEA REPORT INFORMATION'
AND pai.action_context_type = 'PA'
AND pai.action_information1 = 'PYSETADA'
AND pai.action_information_category = 'EMEA REPORT DETAILS'
AND pai2.action_context_type = 'PA'
AND pai2.action_information1 = 'PYSETADA'
AND pai2.action_information_category = 'EMEA REPORT INFORMATION'
AND pai2.action_information2 = 'BAL';

Line: 1862


SELECT decode(trim(csr_v_month),'JANUARY','01',
	'FEBRUARY','02',
	'MARCH','03',
	'APRIL','04',
	'MAY','05',
	'JUNE','06',
	'JULY','07',
	'AUGUST','08',
	'SEPTEMBER','09',
	'OCTOBER','10',
	'NOVEMBER','11',
	'DECEMBER','12') FROM dual;