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_DK_ARCHIVE_EIN dependencies on PAY_BALANCE_PKG

Line 86: l_value := nvl(pay_balance_pkg.get_value(l_context1,p_assignment_id,p_virtual_date), 0);

82: OPEN get_dbal_id(p_balance_name, p_balance_dim);
83: FETCH get_dbal_id INTO l_context1;
84: CLOSE get_dbal_id;
85:
86: l_value := nvl(pay_balance_pkg.get_value(l_context1,p_assignment_id,p_virtual_date), 0);
87:
88: RETURN l_value;
89:
90: END GET_DEFINED_BALANCE_VALUE ;

Line 2248: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);

2244: CLOSE csr_Get_Defined_Balance_Id;
2245:
2246: l_emp_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee Tax','_ASG_PTD' ,l_bal_date);
2247: l_holiday_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Tax','_ASG_PTD' ,l_bal_date);
2248: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2249: /* 10269552 start */
2250: l_g_dage_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'G_Dage Pay Reporting','_ASG_PTD' ,l_bal_date);
2251: /* 10269552 end */
2252:

Line 2259: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);

2255: CLOSE csr_Get_Defined_Balance_Id;
2256:
2257: l_emp_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee AMB Deduction','_ASG_PTD' ,l_bal_date);
2258: l_hol_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday AMB','_ASG_PTD' ,l_bal_date);
2259: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2260: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');
2261:
2262: l_hourly_salaried :=rg_csr_get_person_details.HOURLY_SALARIED_CODE;
2263: if(l_hourly_salaried IS null) then

Line 2469: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);

2465:
2466: l_emp_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee Tax','_ASG_PTD' ,l_bal_date);
2467:
2468: l_holiday_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Tax','_ASG_PTD' ,l_bal_date);
2469: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2470: */
2471:
2472: -- fnd_file.put_line(fnd_file.log,'Hourly Holiday Tax_Payments : '||l_holiday_tax_pay);
2473: -- /* 9945754 */

Line 2489: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);

2485:
2486: l_emp_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee AMB Deduction','_ASG_PTD' ,l_bal_date);
2487:
2488: l_hol_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday AMB','_ASG_PTD' ,l_bal_date);
2489: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2490: */
2491: -- fnd_file.put_line(fnd_file.log,'Holiday AMB Reporting (ASG RUN) : '||l_hol_amb_rep);
2492: /* 9945754 */
2493: /* 101842801 moved to top */

Line 3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3296: IF l_hourly_salaried='H' THEN
3297:
3298: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');
3299:
3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);
3302:
3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);

Line 3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3299:
3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);
3302:
3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);
3305:
3306: l_hol_pay_0202_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3307: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_amb:'||l_hol_pay_0202_amb);

Line 3306: l_hol_pay_0202_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3302:
3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);
3305:
3306: l_hol_pay_0202_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3307: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_amb:'||l_hol_pay_0202_amb);
3308:
3309: --l_hol_pay_0202_sp := NVL(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Hourly Holiday SP','_PAYMENTS' ,l_bal_date),0);
3310:

Line 3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3318: ELSIF l_hourly_salaried='S' THEN
3319:
3320: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=S:');
3321:
3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
3324:
3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);

Line 3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3321:
3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
3324:
3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
3327:
3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);

Line 3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3324:
3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
3327:
3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
3330:
3331: l_sal_hol_acr_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);

Line 3331: l_sal_hol_acr_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3327:
3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
3330:
3331: l_sal_hol_acr_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
3333:
3334: -- l_net_hol_pay_6102_1 := l_sal_hol_acr_amt - (l_sal_hol_acr_tax + l_sal_hol_acr_amb); --13630274
3335: l_net_hol_pay_6102_1 := l_sal_hol_acr_amt ;

Line 3345: l_sal_hol_cur_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3341: END IF;
3342:
3343: l_no_of_hol_6102_1 := l_sal_hol_acr_days;
3344:
3345: l_sal_hol_cur_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3346: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
3347:
3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);

Line 3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3344:
3345: l_sal_hol_cur_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3346: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
3347:
3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
3350:
3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);

Line 3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3347:
3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
3350:
3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
3353:
3354: l_sal_hol_cur_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);

Line 3354: l_sal_hol_cur_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3350:
3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
3353:
3354: l_sal_hol_cur_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
3356:
3357: -- l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt - (l_sal_hol_cur_ent_tax + l_sal_hol_cur_ent_amb); --13630274
3358: l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt;

Line 3368: l_sal_hol_nxt_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3364: END IF;
3365:
3366: l_no_of_hol_6102_2 := l_sal_hol_cur_ent_days;
3367:
3368: l_sal_hol_nxt_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3369: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
3370:
3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);

Line 3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3367:
3368: l_sal_hol_nxt_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3369: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
3370:
3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
3373:
3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);

Line 3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3370:
3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
3373:
3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
3376:
3377: l_sal_hol_nxt_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);

Line 3377: l_sal_hol_nxt_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3373:
3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
3376:
3377: l_sal_hol_nxt_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
3379:
3380: -- l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt - (l_sal_hol_nxt_ent_tax + l_sal_hol_nxt_ent_amb); --13630274
3381: l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt;

Line 3616: l_no_of_hol_6005_0203 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3612: --13463885
3613: IF (l_use_holiday_card ='N' OR (l_uhc_payroll ='N' AND l_use_holiday_card = 'Y' )) AND l_usr_tbl_exist_400 = 'N' THEN
3614: IF l_hourly_salaried='H' THEN
3615:
3616: l_no_of_hol_6005_0203 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3617: fnd_file.put_line(fnd_file.log,'l_no_of_hol_6005_0203 :'||l_no_of_hol_6005_0203);
3618:
3619: IF l_no_of_hol_6005_0203 <> 0 THEN
3620: