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_CBS_FILE dependencies on PAY_NL_GENERAL

Line 236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

232: end if;
233:
234: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_HOLIDAY_HOURS',500);
235: l_defined_balance := 'CBS_HOLIDAY_HOURS'||l_dimension;
236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
237: l_holiday_hours:= nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);
239:
240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);

Line 242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);
239:
240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);
241: l_defined_balance := 'CBS_ADV_HOURS'||l_dimension;
242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);

Line 248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);
251:
252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);

Line 254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);
251:
252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);
253: l_defined_balance := 'SI_INCOME_SPECIAL_TAX'||l_dimension;
254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);

Line 260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);
263:
264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);

Line 266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);
263:
264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);
265: l_defined_balance := 'RETRO_SI_INCOME_SPECIAL_TAX'||l_dimension;
266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
267: l_ret_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);
269:
270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);

Line 272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);
269:
270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);
271: l_defined_balance := 'CBS_UNIQUE_PAYMENTS'||l_dimension;
272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
273: l_unique_payments :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);
275:
276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);

Line 278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);
275:
276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
277: l_defined_balance := 'PRE_TAX_ONLY_DEDUCTIONS'||l_dimension;
278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
279: l_pre_tax_only_ded:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);
281:
282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);

Line 284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);
281:
282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
283: l_defined_balance := 'PRE_TAX_DEDUCTIONS'||l_dimension;
284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
285: l_pre_si_pre_tax_ded :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);
287:
288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);

Line 290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);
287:
288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);
289: l_defined_balance := 'EMPLOYEE_SAVINGS_CONTRIBUTION'||l_dimension;
290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
291: l_saving_scheme:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);
293:
294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);

Line 296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);
293:
294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);
295: l_defined_balance := 'CBS_SICKNESS_DAYS'||l_dimension;
296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
297: l_sickness_days :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);
299:
300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);

Line 302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);
299:
300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);
301: l_defined_balance := 'CBS_SICKNESS_PAY'||l_dimension;
302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
303: l_sickness_pay:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);
305:
306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);

Line 308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);
305:
306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);
307: l_defined_balance := 'CBS_UNPAID_HOURS'||l_dimension;
308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
309: l_unpaid_hours :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);
311:
312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);

Line 314: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);
311:
312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);
313: l_defined_balance := 'CBS_OVERTIME_HOURS'||l_dimension;
314: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
315: l_overtime_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
316: -- hr_utility.set_location('l_overtime_hours'||l_overtime_hours,425);
317:
318: l_si_wage :=round(NVL(l_si_std_tax,0)+NVL(l_si_spl_tax,0)+NVL(l_ret_si_std_tax,0)+ NVL(l_ret_si_spl_tax,0));

Line 379: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

375: fetch csr_get_context_id into l_context_id , l_context_value , l_context_seq;
376: close csr_get_context_id;
377:
378: l_defined_balance := 'CBS_CONTRACT_WAGE'||l_dimension;
379: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
380: l_wage_agreed_by_contract :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
381: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,425);
382:
383: if ( l_context_id is not null and l_context_value is not null ) then

Line 387: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

383: if ( l_context_id is not null and l_context_value is not null ) then
384: if (p_frequency = 'M') then
385: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH',500);
386: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH';
387: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
388: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
389: -- hr_utility.set_location('l_number_of_days'||l_number_of_days,425);
390: else
391: if (p_frequency = 'K') then

Line 394: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

390: else
391: if (p_frequency = 'K') then
392: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
393: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
394: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
395: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
396: else
397: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH',500);
398: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH';

Line 399: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

395: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
396: else
397: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH',500);
398: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH';
399: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
400: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
401: end if;
402: end if;
403:

Line 406: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

402: end if;
403:
404: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
405: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
406: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
407: l_si_days_quarter := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
408: -- hr_utility.set_location('l_si_days_quarter'||l_si_days_quarter,425);
409: else
410: l_number_of_days := 0;

Line 416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

412: end if;
413:
414: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_PAID_GROSS_WAGE',500);
415: l_defined_balance := 'CBS_PAID_GROSS_WAGE'||l_dimension;
416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
417: l_paid_gross_wage :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);
419:
420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);

Line 422: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);
419:
420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);
421: l_defined_balance := 'CBS_OVERTIME_WAGE'||l_dimension;
422: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
423: l_wage_for_overtime :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
424: -- hr_utility.set_location('l_wage_for_overtime'||l_wage_for_overtime,425);
425:
426: return 1;

Line 687: PAY_NL_GENERAL.cache_formula('NL_WEEKLY_WORKING_HOURS',p_business_group_id,p_reporting_date,l_formula_id,l_formula_exists,l_formula_cached);

683: -- hr_utility.set_location('--In Get Working Hours ',10);
684: g_working_hours_formula_name := 'NL_WEEKLY_WORKING_HOURS';
685: IF g_working_hours_formula_exists = TRUE THEN
686: IF g_working_hours_formula_cached = FALSE THEN
687: PAY_NL_GENERAL.cache_formula('NL_WEEKLY_WORKING_HOURS',p_business_group_id,p_reporting_date,l_formula_id,l_formula_exists,l_formula_cached);
688: g_working_hours_formula_exists:=l_formula_exists;
689: g_working_hours_formula_cached:=l_formula_cached;
690: g_working_hours_formula_id:=l_formula_id;
691: END IF;

Line 703: PAY_NL_GENERAL.run_formula(p_formula_id => g_working_hours_formula_id,

699: l_inputs(2).value := p_assignment_id;
700:
701: l_outputs(1).name := 'WEEKLY_WORKING_HOURS';
702:
703: PAY_NL_GENERAL.run_formula(p_formula_id => g_working_hours_formula_id,
704: p_effective_date => g_reporting_date,
705: p_formula_name => g_working_hours_formula_name,
706: p_inputs => l_inputs,
707: p_outputs => l_outputs);

Line 721: weeks_per_month := pay_nl_general.get_global_value(p_reporting_date,'NL_TAX_WEEKS_PER_MONTH');

717: OPEN csr_get_freq_ind_hours(p_assignment_id,p_reporting_date);
718: fetch csr_get_freq_ind_hours into l_ind_work_hours2,l_frequency;
719: close csr_get_freq_ind_hours;
720: l_ind_work_hours := fnd_number.canonical_to_number(l_ind_work_hours2);
721: weeks_per_month := pay_nl_general.get_global_value(p_reporting_date,'NL_TAX_WEEKS_PER_MONTH');
722: if l_frequency = 'M' then
723: l_weekly_working_hours := l_ind_work_hours/fnd_number.canonical_to_number(weeks_per_month);
724: else
725: if l_frequency = 'D' then

Line 908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);

904: open csr_get_date_earned(p_max_assgt_act_id);
905: fetch csr_get_date_earned into l_date_earned;
906: close csr_get_date_Earned;
907:
908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);
909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);
910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);
911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);
912:

Line 909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);

905: fetch csr_get_date_earned into l_date_earned;
906: close csr_get_date_Earned;
907:
908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);
909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);
910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);
911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);
912:
913: open csr_run_result_id ( p_max_assgt_act_id ,l_element_type_id) ;

Line 910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);

906: close csr_get_date_Earned;
907:
908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);
909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);
910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);
911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);
912:
913: open csr_run_result_id ( p_max_assgt_act_id ,l_element_type_id) ;
914: fetch csr_run_result_id into l_run_result_id;

Line 911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);

907:
908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);
909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);
910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);
911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);
912:
913: open csr_run_result_id ( p_max_assgt_act_id ,l_element_type_id) ;
914: fetch csr_run_result_id into l_run_result_id;
915: close csr_run_Result_id;

Line 917: if pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_tax_discount_input_id,l_run_result_id,'C') = 'NL_NONE' then

913: open csr_run_result_id ( p_max_assgt_act_id ,l_element_type_id) ;
914: fetch csr_run_result_id into l_run_result_id;
915: close csr_run_Result_id;
916:
917: if pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_tax_discount_input_id,l_run_result_id,'C') = 'NL_NONE' then
918: p_wage_tax_discount := '00';
919: else
920: p_wage_tax_discount := '01';
921: end if;

Line 923: p_tax_code := pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_tax_code_input_id,l_run_result_id,'C');

919: else
920: p_wage_tax_discount := '01';
921: end if;
922:
923: p_tax_code := pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_tax_code_input_id,l_run_result_id,'C');
924:
925: if pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_labour_relation_code_id,l_run_result_id,'C') = 'N' then
926: p_labour_relation_code := '00';
927: else

Line 925: if pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_labour_relation_code_id,l_run_result_id,'C') = 'N' then

921: end if;
922:
923: p_tax_code := pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_tax_code_input_id,l_run_result_id,'C');
924:
925: if pay_nl_general.get_run_result_value(p_max_assgt_act_id,l_element_type_id,l_labour_relation_code_id,l_run_result_id,'C') = 'N' then
926: p_labour_relation_code := '00';
927: else
928: p_labour_relation_code := '01';
929: end if;

Line 1077: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS

1073: p_telephone => l_employer_telephone);
1074:
1075: -- hr_utility.set_location('Executing GET BG ADDRESS',600);
1076:
1077: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS
1078: (l_business_group_id,
1079: l_business_group_id,
1080: l_sen_house_number,
1081: l_sen_house_no_add,

Line 1092: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS

1088: l_sen_postal_code);
1089:
1090: -- hr_utility.set_location('Executing GET ORG ADDRESS',600);
1091:
1092: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS
1093: (l_employer
1094: ,l_business_group_id
1095: ,l_house_number
1096: ,l_house_no_add