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_BALANCE_PKG

Line 237: l_holiday_hours:= nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
241: l_defined_balance := 'CBS_ADV_HOURS'||l_dimension;

Line 243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;

Line 249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
253: l_defined_balance := 'SI_INCOME_SPECIAL_TAX'||l_dimension;

Line 255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;

Line 261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
265: l_defined_balance := 'RETRO_SI_INCOME_SPECIAL_TAX'||l_dimension;

Line 267: l_ret_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
271: l_defined_balance := 'CBS_UNIQUE_PAYMENTS'||l_dimension;

Line 273: l_unique_payments :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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);
277: l_defined_balance := 'PRE_TAX_ONLY_DEDUCTIONS'||l_dimension;

Line 279: l_pre_tax_only_ded:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
283: l_defined_balance := 'PRE_TAX_DEDUCTIONS'||l_dimension;

Line 285: l_pre_si_pre_tax_ded :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
289: l_defined_balance := 'EMPLOYEE_SAVINGS_CONTRIBUTION'||l_dimension;

Line 291: l_saving_scheme:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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);
295: l_defined_balance := 'CBS_SICKNESS_DAYS'||l_dimension;

Line 297: l_sickness_days :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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);
301: l_defined_balance := 'CBS_SICKNESS_PAY'||l_dimension;

Line 303: l_sickness_pay:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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);
307: l_defined_balance := 'CBS_UNPAID_HOURS'||l_dimension;

Line 309: l_unpaid_hours :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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);
313: l_defined_balance := 'CBS_OVERTIME_HOURS'||l_dimension;

Line 315: l_overtime_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);

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));
319: l_pre_tax_deductions := round(NVL(l_pre_si_pre_tax_ded,0)- NVL(l_pre_tax_only_ded,0));

Line 380: l_wage_agreed_by_contract :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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
384: if (p_frequency = 'M') then

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

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
392: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);

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

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';
399: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

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

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:
404: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);

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

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;
411: l_si_days_quarter := 0;

Line 417: l_paid_gross_wage :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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);
421: l_defined_balance := 'CBS_OVERTIME_WAGE'||l_dimension;

Line 423: l_wage_for_overtime :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));

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;
427: -- hr_utility.set_location('Exited get_balances2',425);