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_NL_SOE dependencies on STANDARD

Line 187: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Code');

183: FETCH cur_spl_rate INTO l_prev_tax_income;
184: CLOSE cur_spl_rate;
185:
186: --Fetch Tax code
187: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Code');
188: FETCH cur_spl_rate INTO l_Tax_Code;
189: CLOSE cur_spl_rate;
190:
191: --Fetch Tax Table Colour

Line 192: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Table');

188: FETCH cur_spl_rate INTO l_Tax_Code;
189: CLOSE cur_spl_rate;
190:
191: --Fetch Tax Table Colour
192: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Table');
193: FETCH cur_spl_rate INTO l_Tax_Table;
194: CLOSE cur_spl_rate;
195: l_Tax_Table := hr_general.decode_lookup('NL_TAX_TABLE',l_Tax_Table);
196: l_Tax_Table := replace(l_Tax_table,'''','||fnd_global.local_chr(39)');

Line 199: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Reduction Flag');

195: l_Tax_Table := hr_general.decode_lookup('NL_TAX_TABLE',l_Tax_Table);
196: l_Tax_Table := replace(l_Tax_table,'''','||fnd_global.local_chr(39)');
197:
198: --Fetch Tax Reduction Flag
199: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Reduction Flag');
200: FETCH cur_spl_rate INTO l_Tax_Reduction;
201: CLOSE cur_spl_rate;
202: l_Tax_Reduction := hr_general.decode_lookup('HR_NL_REPORT_LABELS',l_Tax_Reduction);
203: l_Tax_Reduction := replace(l_Tax_Reduction,'''','||fnd_global.local_chr(39)');

Line 206: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Labour Tax Reduction Flag');

202: l_Tax_Reduction := hr_general.decode_lookup('HR_NL_REPORT_LABELS',l_Tax_Reduction);
203: l_Tax_Reduction := replace(l_Tax_Reduction,'''','||fnd_global.local_chr(39)');
204:
205: --Fetch Labour Tax Reduction Flag
206: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Labour Tax Reduction Flag');
207: FETCH cur_spl_rate INTO l_Labour_Tax_Reduction;
208: CLOSE cur_spl_rate;
209: l_Labour_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Labour_Tax_Reduction);
210: l_Labour_Tax_Reduction := replace(l_Labour_Tax_Reduction,'''','||fnd_global.local_chr(39)');

Line 213: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Additional Senior Tax Flag');

209: l_Labour_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Labour_Tax_Reduction);
210: l_Labour_Tax_Reduction := replace(l_Labour_Tax_Reduction,'''','||fnd_global.local_chr(39)');
211:
212: --Fetch Additional Senior Tax Reduction Flag
213: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Additional Senior Tax Flag');
214: FETCH cur_spl_rate INTO l_Senior_Tax_Reduction;
215: CLOSE cur_spl_rate;
216: l_Senior_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Senior_Tax_Reduction);
217: l_Senior_Tax_Reduction := replace(l_Senior_Tax_Reduction,'''','||fnd_global.local_chr(39)');

Line 220: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Special Indicators');

216: l_Senior_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Senior_Tax_Reduction);
217: l_Senior_Tax_Reduction := replace(l_Senior_Tax_Reduction,'''','||fnd_global.local_chr(39)');
218:
219: --Fetch Special Tax Indicators
220: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Special Indicators');
221: FETCH cur_spl_rate INTO l_Special_Indicators;
222: CLOSE cur_spl_rate;
223:
224: l_sp_percentage_rate:= NVL(l_sp_percentage_rate,0);

Line 243: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_PTD');

239:
240: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_WAO_ALLOWANCE_ASG_PTD');
241: l_WAO_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
242:
243: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_PTD');
244:
245: open get_context_id;
246: fetch get_context_id into l_context_id;
247: close get_context_id;