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 PAY_NL_GENERAL

Line 228: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_TRAVEL_ALLOWANCE_ASG_PTD');

224: l_sp_percentage_rate:= NVL(l_sp_percentage_rate,0);
225: l_prev_tax_income:= NVL(l_prev_tax_income,0);
226: -- Fetch Balances
227: --
228: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_TRAVEL_ALLOWANCE_ASG_PTD');
229: l_Travel_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
230:
231: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_SEA_DAYS_DISCOUNT_ASG_PTD');
232: l_Sea_Days_Discount := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);

Line 231: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_SEA_DAYS_DISCOUNT_ASG_PTD');

227: --
228: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_TRAVEL_ALLOWANCE_ASG_PTD');
229: l_Travel_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
230:
231: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_SEA_DAYS_DISCOUNT_ASG_PTD');
232: l_Sea_Days_Discount := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
233:
234: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_ASG_PTD');
235: l_ABW_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);

Line 234: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_ASG_PTD');

230:
231: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_SEA_DAYS_DISCOUNT_ASG_PTD');
232: l_Sea_Days_Discount := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
233:
234: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_ASG_PTD');
235: l_ABW_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
236:
237: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_PTD');
238: l_ABW_Allowance_Stoppage := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);

Line 237: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_PTD');

233:
234: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_ASG_PTD');
235: l_ABW_Allowance := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
236:
237: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_PTD');
238: l_ABW_Allowance_Stoppage := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
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);

Line 240: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_WAO_ALLOWANCE_ASG_PTD');

236:
237: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_PTD');
238: l_ABW_Allowance_Stoppage := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id),0);
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:

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;

Line 249: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_PTD');

245: open get_context_id;
246: fetch get_context_id into l_context_id;
247: close get_context_id;
248: l_ZVW_Contribution := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
249: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_PTD');
250: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
251: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_PTD');
252: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
253:

Line 251: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_PTD');

247: close get_context_id;
248: l_ZVW_Contribution := NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
249: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_PTD');
250: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
251: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_PTD');
252: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
253:
254: l_sql :=
255: 'SELECT TO_CHAR('||l_sp_percentage_rate|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16 '||

Line 294: , pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03

290: --
291: l_sql :=
292: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
293: , nvl(ettl.reporting_name,ettl.element_name) COL02
294: , pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03
295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
298: || ''''''SI Type Name'''''' || '')'') COL04

Line 295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',

291: l_sql :=
292: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
293: , nvl(ettl.reporting_name,ettl.element_name) COL02
294: , pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03
295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
298: || ''''''SI Type Name'''''' || '')'') COL04
299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

Line 296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)

292: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
293: , nvl(ettl.reporting_name,ettl.element_name) COL02
294: , pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03
295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
298: || ''''''SI Type Name'''''' || '')'') COL04
299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator

Line 297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''

293: , nvl(ettl.reporting_name,ettl.element_name) COL02
294: , pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'') COL03
295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
298: || ''''''SI Type Name'''''' || '')'') COL04
299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18

Line 335: ,pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'')

331: OR es.LEGISLATION_CODE = '':legislation_code'' )
332: and es.element_set_name = '''|| p_element_set_name ||'''
333: group by nvl(ettl.reporting_name,ettl.element_name)
334: , ettl.reporting_name
335: ,pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name'')
336: ,nvl(ettl.reporting_name,et.element_type_id)
337: order by nvl(ettl.reporting_name,ettl.element_name),nvl(ettl.reporting_name,et.element_type_id)';
338: --
339: --

Line 366: pay_nl_general.get_sit_type_name

362:
363: Text : Constructs the SQL for the Balances and YTD Values Region of SOE
364: similar to Core Function - pay_soe_glb.getBalances
365: Only difference-Returns SI Type Name by calling
366: pay_nl_general.get_sit_type_name
367: ------------------------------------------------------------------------ */
368: function getBalances(p_assignment_action_id number
369: ,p_balance_attribute varchar2) return long is
370: --

Line 695: l_si_type_name := pay_nl_general.get_sit_type_name(l_balance_type_lst(l_output_table(i).defined_balance_id).balance_type_id

691: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
692: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
693: l_si_type_name := NULL;
694: IF l_output_table(i).source_text IS NOT NULL THEN
695: l_si_type_name := pay_nl_general.get_sit_type_name(l_balance_type_lst(l_output_table(i).defined_balance_id).balance_type_id
696: ,locked_assignment_action_id,l_effective_date,l_output_table(i).source_text);
697:
698: /* Bug 4253982 */
699: IF l_si_type_name IS NULL THEN

Line 703: l_si_type_name := pay_nl_general.get_sit_type_name(l_balance_type_lst(l_output_table(i).defined_balance_id).balance_type_id

699: IF l_si_type_name IS NULL THEN
700:
701: FOR l_asg_actions in getAsgActions(locked_assignment_action_id,l_effective_date) loop
702:
703: l_si_type_name := pay_nl_general.get_sit_type_name(l_balance_type_lst(l_output_table(i).defined_balance_id).balance_type_id
704: ,l_asg_actions.assignment_action_id,l_effective_date,l_output_table(i).source_text);
705: IF l_si_type_name IS NOT NULL THEN
706: EXIT;
707: END IF;