DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on HR_GENERAL

Line 195: l_Tax_Table := hr_general.decode_lookup('NL_TAX_TABLE',l_Tax_Table);

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)');
197:
198: --Fetch Tax Reduction Flag
199: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Tax Reduction Flag');

Line 202: l_Tax_Reduction := hr_general.decode_lookup('HR_NL_REPORT_LABELS',l_Tax_Reduction);

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)');
204:
205: --Fetch Labour Tax Reduction Flag
206: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Labour Tax Reduction Flag');

Line 209: l_Labour_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Labour_Tax_Reduction);

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)');
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');

Line 216: l_Senior_Tax_Reduction := hr_general.decode_lookup('HR_NL_YES_NO',l_Senior_Tax_Reduction);

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)');
218:
219: --Fetch Special Tax Indicators
220: OPEN cur_spl_rate(l_locked_assignment_action_id,'Standard Tax Deduction','Special Indicators');

Line 683: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))

679: pay_soe_util.setValue('04'
680: ,l_balance_type_lst(l_output_table(i).defined_balance_id).defined_balance_name
681: ,FALSE,FALSE);
682: pay_soe_util.setValue('05',
683: hr_general.decode_organization(to_char(l_output_table(i).tax_unit_id))
684: ,FALSE,FALSE);
685: pay_soe_util.setValue('06',to_char(l_output_table(i).tax_unit_id),FALSE,FALSE);
686:
687: