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 dependencies on PAY_ACTION_INFORMATION

Line 90: l_payroll_action_id pay_action_information.action_information1%TYPE;

86: /* Start of declaration*/
87: -- Variables needed for the report
88: l_sum NUMBER;
89: l_counter NUMBER := 1;
90: l_payroll_action_id pay_action_information.action_information1%TYPE;
91: l_digit1 NUMBER(1);
92: l_digit2 NUMBER(1);
93: l_digit3 NUMBER(1);
94: l_digit4 NUMBER(1);

Line 175: pay_action_information pai,

171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
177: pay_action_information pai1,
178: pay_action_information pai2
179: WHERE

Line 177: pay_action_information pai1,

173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
177: pay_action_information pai1,
178: pay_action_information pai2
179: WHERE
180: pai.action_context_id = ppa.payroll_action_id
181: AND ppa.payroll_action_id =csr_v_pa_id

Line 178: pay_action_information pai2

174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
177: pay_action_information pai1,
178: pay_action_information pai2
179: WHERE
180: pai.action_context_id = ppa.payroll_action_id
181: AND ppa.payroll_action_id =csr_v_pa_id
182: AND pai.action_context_id = pai1.action_context_id

Line 1785: l_payroll_action_id pay_action_information.action_information1%TYPE;

1781: /* Start of declaration*/
1782: -- Variables needed for the report
1783: l_sum NUMBER;
1784: l_counter NUMBER := 1;
1785: l_payroll_action_id pay_action_information.action_information1%TYPE;
1786: l_xfdf_string CLOB;
1787: l_str1 varchar2(2000);
1788:
1789: cursor csr_Tax_Decl (csr_v_pa_id IN VARCHAR2)

Line 1837: pay_action_information pai,

1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1839: pay_action_information pai1,
1840: pay_action_information pai2
1841: WHERE

Line 1839: pay_action_information pai1,

1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1839: pay_action_information pai1,
1840: pay_action_information pai2
1841: WHERE
1842: pai.action_context_id = ppa.payroll_action_id
1843: AND ppa.payroll_action_id =csr_v_pa_id

Line 1840: pay_action_information pai2

1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1839: pay_action_information pai1,
1840: pay_action_information pai2
1841: WHERE
1842: pai.action_context_id = ppa.payroll_action_id
1843: AND ppa.payroll_action_id =csr_v_pa_id
1844: AND pai.action_context_id = pai1.action_context_id