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

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

118: OPEN get_dbal_id(p_balance_name, p_balance_dim);
119: FETCH get_dbal_id INTO l_context1;
120: CLOSE get_dbal_id;
121:
122: l_value := nvl(pay_balance_pkg.get_value(l_context1,p_assignment_id,p_virtual_date), 0);
123:
124: RETURN l_value;
125:
126: END GET_DEFINED_BALANCE_VALUE ;

Line 2270: l_holiday_pay_hr := 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);

2266: IF l_hourly_salaried='H' THEN
2267:
2268: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');
2269:
2270: l_holiday_pay_hr := 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);
2271: fnd_file.put_line(fnd_file.log,'l_holiday_pay_hr:'||l_holiday_pay_hr);
2272:
2273: l_hol_tax_hr := 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);
2274: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);

Line 2273: l_hol_tax_hr := 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);

2269:
2270: l_holiday_pay_hr := 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);
2271: fnd_file.put_line(fnd_file.log,'l_holiday_pay_hr:'||l_holiday_pay_hr);
2272:
2273: l_hol_tax_hr := 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);
2274: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);
2275:
2276: l_hol_amb_hr := 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);
2277: fnd_file.put_line(fnd_file.log,'l_hol_amb_hr:'||l_hol_amb_hr);

Line 2276: l_hol_amb_hr := 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);

2272:
2273: l_hol_tax_hr := 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);
2274: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);
2275:
2276: l_hol_amb_hr := 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);
2277: fnd_file.put_line(fnd_file.log,'l_hol_amb_hr:'||l_hol_amb_hr);
2278:
2279: --l_hol_pay_0202_sp := NVL(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Hourly Holiday SP','_PAYMENTS' ,l_bal_date),0);
2280:

Line 2284: l_Holidayable_amount_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2280:
2281: --l_net_hol_pay_0202 := l_hol_pay_0202 - (l_hol_pay_0202_tax + l_hol_pay_0202_amb );
2282: --fnd_file.put_line(fnd_file.log,'l_net_hol_pay_0202:'||l_net_hol_pay_0202);
2283:
2284: l_Holidayable_amount_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2285: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_hr:'||l_Holidayable_amount_hr);
2286:
2287: l_tot_holiday_pay_hr := l_holiday_pay_hr + l_hol_tax_hr + l_hol_amb_hr ;
2288: fnd_file.put_line(fnd_file.log,'l_tot_holiday_pay_hr:'||l_tot_holiday_pay_hr);

Line 2293: l_tot_no_holidays_hr := 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);

2289:
2290: l_taxable_hol_pay_hr := l_tot_holiday_pay_hr - l_hol_amb_hr ;
2291: fnd_file.put_line(fnd_file.log,'l_taxable_hol_pay_hr:'||l_taxable_hol_pay_hr);
2292:
2293: l_tot_no_holidays_hr := 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);
2294: fnd_file.put_line(fnd_file.log,'l_tot_no_holidays_hr:'||l_tot_no_holidays_hr);
2295:
2296: IF l_tot_no_holidays_hr <> 0 THEN
2297: l_hol_pay_per_holiday_hr := (l_holiday_pay_hr / l_tot_no_holidays_hr);

Line 2301: l_profit_free_ch_ac_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2297: l_hol_pay_per_holiday_hr := (l_holiday_pay_hr / l_tot_no_holidays_hr);
2298: END IF;
2299: fnd_file.put_line(fnd_file.log,'l_hol_pay_per_holiday_hr:'||l_hol_pay_per_holiday_hr);
2300:
2301: l_profit_free_ch_ac_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2302: fnd_file.put_line(fnd_file.log,'l_profit_free_ch_ac_hr:'||l_profit_free_ch_ac_hr);
2303:
2304: l_net_hol_pay_hr := l_holiday_pay_hr + l_profit_free_ch_ac_hr ;
2305: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_hr:'||l_net_hol_pay_hr);

Line 2307: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2303:
2304: l_net_hol_pay_hr := l_holiday_pay_hr + l_profit_free_ch_ac_hr ;
2305: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_hr:'||l_net_hol_pay_hr);
2306:
2307: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2308: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_hr:'||l_hol_pay_sick_hr);
2309:
2310: --
2311: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

Line 2311: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2307: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2308: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_hr:'||l_hol_pay_sick_hr);
2309:
2310: --
2311: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2312: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_hr:'||l_hol_days_paid_hr);
2313:
2314: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2315: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);

Line 2314: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2310: --
2311: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2312: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_hr:'||l_hol_days_paid_hr);
2313:
2314: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2315: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);
2316:
2317: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2318: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);

Line 2317: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2313:
2314: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2315: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);
2316:
2317: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2318: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);
2319:
2320: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2321: fnd_file.put_line(fnd_file.log,'l_hrly_hol_days_hr:'||l_hrly_hol_days_hr);

Line 2320: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2316:
2317: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2318: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);
2319:
2320: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2321: fnd_file.put_line(fnd_file.log,'l_hrly_hol_days_hr:'||l_hrly_hol_days_hr);
2322: --
2323:
2324: ELSIF l_hourly_salaried='S' THEN

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

2324: ELSIF l_hourly_salaried='S' THEN
2325:
2326: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=S:');
2327:
2328: 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);
2329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
2330:
2331: 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);
2332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);

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

2327:
2328: 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);
2329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
2330:
2331: 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);
2332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
2333:
2334: 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);
2335: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);

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

2330:
2331: 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);
2332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
2333:
2334: 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);
2335: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
2336:
2337: 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);
2338: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);

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

2333:
2334: 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);
2335: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
2336:
2337: 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);
2338: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
2339:
2340: --l_net_hol_pay_6102_1 := l_sal_hol_acr_amt - (l_sal_hol_acr_tax + l_sal_hol_acr_amb);
2341:

Line 2342: l_Holidayable_amount_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2338: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
2339:
2340: --l_net_hol_pay_6102_1 := l_sal_hol_acr_amt - (l_sal_hol_acr_tax + l_sal_hol_acr_amb);
2341:
2342: l_Holidayable_amount_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2343: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_1:'||l_Holidayable_amount_1);
2344:
2345: l_holiday_pay_1 := l_sal_hol_acr_amt;
2346: fnd_file.put_line(fnd_file.log,'l_holiday_pay_1:'||l_holiday_pay_1);

Line 2359: l_profit_free_ch_ac_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2355: l_hol_pay_per_holiday_1 := (l_holiday_pay_1 / l_sal_hol_acr_days);
2356: END IF;
2357: fnd_file.put_line(fnd_file.log,'l_hol_pay_per_holiday_1:'||l_hol_pay_per_holiday_1);
2358:
2359: l_profit_free_ch_ac_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2360: fnd_file.put_line(fnd_file.log,'l_profit_free_ch_ac_1:'||l_profit_free_ch_ac_1);
2361:
2362: l_net_hol_pay_1 := l_holiday_pay_1 + l_profit_free_ch_ac_1 ;
2363: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_1:'||l_net_hol_pay_1);

Line 2365: l_hol_pay_sick_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2361:
2362: l_net_hol_pay_1 := l_holiday_pay_1 + l_profit_free_ch_ac_1 ;
2363: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_1:'||l_net_hol_pay_1);
2364:
2365: l_hol_pay_sick_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2366: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_1:'||l_hol_pay_sick_1);
2367:
2368: --
2369: 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);

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

2365: l_hol_pay_sick_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2366: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_1:'||l_hol_pay_sick_1);
2367:
2368: --
2369: 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);
2370: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
2371:
2372: 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);
2373: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);

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

2368: --
2369: 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);
2370: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
2371:
2372: 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);
2373: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
2374:
2375: 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);
2376: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);

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

2371:
2372: 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);
2373: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
2374:
2375: 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);
2376: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
2377:
2378: 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);
2379: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);

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

2374:
2375: 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);
2376: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
2377:
2378: 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);
2379: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
2380:
2381: --l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt - (l_sal_hol_cur_ent_tax + l_sal_hol_cur_ent_amb);
2382:

Line 2383: --l_Holidayable_amount_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2379: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
2380:
2381: --l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt - (l_sal_hol_cur_ent_tax + l_sal_hol_cur_ent_amb);
2382:
2383: --l_Holidayable_amount_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2384: --fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_3:'||l_Holidayable_amount_3);
2385:
2386: l_holiday_pay_3 := l_sal_hol_cur_ent_amt;
2387: fnd_file.put_line(fnd_file.log,'l_holiday_pay_3:'||l_holiday_pay_3);

Line 2400: l_profit_free_ch_ac_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2396: l_hol_pay_per_holiday_3 := (l_holiday_pay_3 / l_sal_hol_cur_ent_amt);
2397: END IF;
2398: fnd_file.put_line(fnd_file.log,'l_hol_pay_per_holiday_3:'||l_hol_pay_per_holiday_3);
2399:
2400: l_profit_free_ch_ac_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2401: fnd_file.put_line(fnd_file.log,'l_profit_free_ch_ac_3:'||l_profit_free_ch_ac_3);
2402:
2403: l_net_hol_pay_3 := l_holiday_pay_3 + l_profit_free_ch_ac_3 ;
2404: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_3:'||l_net_hol_pay_3);

Line 2406: l_hol_pay_sick_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2402:
2403: l_net_hol_pay_3 := l_holiday_pay_3 + l_profit_free_ch_ac_3 ;
2404: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_3:'||l_net_hol_pay_3);
2405:
2406: l_hol_pay_sick_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2407: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_3:'||l_hol_pay_sick_3);
2408:
2409: --
2410: 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);

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

2406: l_hol_pay_sick_3 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2407: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_3:'||l_hol_pay_sick_3);
2408:
2409: --
2410: 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);
2411: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
2412:
2413: 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);
2414: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);

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

2409: --
2410: 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);
2411: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
2412:
2413: 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);
2414: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
2415:
2416: 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);
2417: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);

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

2412:
2413: 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);
2414: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
2415:
2416: 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);
2417: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
2418:
2419: 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);
2420: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);

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

2415:
2416: 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);
2417: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
2418:
2419: 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);
2420: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
2421:
2422: --l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt - (l_sal_hol_nxt_ent_tax + l_sal_hol_nxt_ent_amb);
2423:

Line 2424: --l_Holidayable_amount_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2420: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
2421:
2422: --l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt - (l_sal_hol_nxt_ent_tax + l_sal_hol_nxt_ent_amb);
2423:
2424: --l_Holidayable_amount_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2425: --fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_2:'||l_Holidayable_amount_2);
2426:
2427: l_holiday_pay_2 := l_sal_hol_nxt_ent_amt;
2428: fnd_file.put_line(fnd_file.log,'l_holiday_pay_2:'||l_holiday_pay_2);

Line 2441: l_profit_free_ch_ac_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2437: l_hol_pay_per_holiday_2 := (l_holiday_pay_2 / l_sal_hol_nxt_ent_amt);
2438: END IF;
2439: fnd_file.put_line(fnd_file.log,'l_hol_pay_per_holiday_2:'||l_hol_pay_per_holiday_2);
2440:
2441: l_profit_free_ch_ac_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2442: fnd_file.put_line(fnd_file.log,'l_profit_free_ch_ac_2:'||l_profit_free_ch_ac_2);
2443:
2444: l_net_hol_pay_2 := l_holiday_pay_2 + l_profit_free_ch_ac_2 ;
2445: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_2:'||l_net_hol_pay_2);

Line 2447: l_hol_pay_sick_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2443:
2444: l_net_hol_pay_2 := l_holiday_pay_2 + l_profit_free_ch_ac_2 ;
2445: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_2:'||l_net_hol_pay_2);
2446:
2447: l_hol_pay_sick_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2448: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_2:'||l_hol_pay_sick_2);
2449: --
2450: l_hol_days_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2451: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_1:'||l_hol_days_paid_1);

Line 2450: l_hol_days_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2446:
2447: l_hol_pay_sick_2 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2448: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_2:'||l_hol_pay_sick_2);
2449: --
2450: l_hol_days_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2451: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_1:'||l_hol_days_paid_1);
2452:
2453: l_hol_pay_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2454: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_1:'||l_hol_pay_paid_1);

Line 2453: l_hol_pay_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2449: --
2450: l_hol_days_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2451: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_1:'||l_hol_days_paid_1);
2452:
2453: l_hol_pay_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2454: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_1:'||l_hol_pay_paid_1);
2455:
2456: l_sal_hol_pay_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2457: fnd_file.put_line(fnd_file.log,'l_sal_hol_pay_1:'||l_sal_hol_pay_1);

Line 2456: l_sal_hol_pay_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2452:
2453: l_hol_pay_paid_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2454: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_1:'||l_hol_pay_paid_1);
2455:
2456: l_sal_hol_pay_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2457: fnd_file.put_line(fnd_file.log,'l_sal_hol_pay_1:'||l_sal_hol_pay_1);
2458:
2459: l_sal_hol_days_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2460: fnd_file.put_line(fnd_file.log,'l_sal_hol_days_1:'||l_sal_hol_days_1);

Line 2459: l_sal_hol_days_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2455:
2456: l_sal_hol_pay_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2457: fnd_file.put_line(fnd_file.log,'l_sal_hol_pay_1:'||l_sal_hol_pay_1);
2458:
2459: l_sal_hol_days_1 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2460: fnd_file.put_line(fnd_file.log,'l_sal_hol_days_1:'||l_sal_hol_days_1);
2461:
2462: --
2463:

Line 2916: l_holiday_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2912: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE PYDKEHOLCA_ANN');
2913:
2914: IF (l_use_holiday_card ='Y' AND l_uhc_payroll ='Y') AND l_usr_tbl_exist_400 = 'N' THEN
2915:
2916: l_holiday_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2917: fnd_file.put_line(fnd_file.log,'l_holiday_pay_hr:'||l_holiday_pay_hr);
2918:
2919: l_hol_tax_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2920: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);

Line 2919: l_hol_tax_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2915:
2916: l_holiday_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2917: fnd_file.put_line(fnd_file.log,'l_holiday_pay_hr:'||l_holiday_pay_hr);
2918:
2919: l_hol_tax_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2920: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);
2921:
2922: l_hol_amb_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2923: fnd_file.put_line(fnd_file.log,'l_hol_amb_hr:'||l_hol_amb_hr);

Line 2922: l_hol_amb_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2918:
2919: l_hol_tax_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2920: fnd_file.put_line(fnd_file.log,'l_hol_tax_hr:'||l_hol_tax_hr);
2921:
2922: l_hol_amb_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2923: fnd_file.put_line(fnd_file.log,'l_hol_amb_hr:'||l_hol_amb_hr);
2924: /*
2925: l_Holidayable_amount_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2926: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_hr:'||l_Holidayable_amount_hr);

Line 2925: l_Holidayable_amount_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2921:
2922: l_hol_amb_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2923: fnd_file.put_line(fnd_file.log,'l_hol_amb_hr:'||l_hol_amb_hr);
2924: /*
2925: l_Holidayable_amount_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holidayable Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2926: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_hr:'||l_Holidayable_amount_hr);
2927: */
2928: l_tot_holiday_pay_hr := l_holiday_pay_hr + l_hol_tax_hr + l_hol_amb_hr ;
2929: fnd_file.put_line(fnd_file.log,'l_tot_holiday_pay_hr:'||l_tot_holiday_pay_hr);

Line 2934: l_tot_no_holidays_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2930:
2931: l_taxable_hol_pay_hr := l_tot_holiday_pay_hr - l_hol_amb_hr ;
2932: fnd_file.put_line(fnd_file.log,'l_taxable_hol_pay_hr:'||l_taxable_hol_pay_hr);
2933:
2934: l_tot_no_holidays_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2935: fnd_file.put_line(fnd_file.log,'l_tot_no_holidays_hr:'||l_tot_no_holidays_hr);
2936:
2937: IF l_tot_no_holidays_hr <> 0 THEN
2938: l_hol_pay_per_holiday_hr := (l_holiday_pay_hr / l_tot_no_holidays_hr);

Line 2942: l_profit_free_ch_ac_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2938: l_hol_pay_per_holiday_hr := (l_holiday_pay_hr / l_tot_no_holidays_hr);
2939: END IF;
2940: fnd_file.put_line(fnd_file.log,'l_hol_pay_per_holiday_hr:'||l_hol_pay_per_holiday_hr);
2941: /*
2942: l_profit_free_ch_ac_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2943: fnd_file.put_line(fnd_file.log,'l_profit_free_ch_ac_hr:'||l_profit_free_ch_ac_hr);
2944: */
2945: l_net_hol_pay_hr := l_holiday_pay_hr + l_profit_free_ch_ac_hr ;
2946: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_hr:'||l_net_hol_pay_hr);

Line 2948: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2944: */
2945: l_net_hol_pay_hr := l_holiday_pay_hr + l_profit_free_ch_ac_hr ;
2946: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_hr:'||l_net_hol_pay_hr);
2947: /*
2948: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2949: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_hr:'||l_hol_pay_sick_hr);
2950: */
2951: --
2952: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

Line 2952: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2948: l_hol_pay_sick_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Sick Pay Subject to Holiday Accrual','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2949: fnd_file.put_line(fnd_file.log,'l_hol_pay_sick_hr:'||l_hol_pay_sick_hr);
2950: */
2951: --
2952: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2953: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_hr:'||l_hol_days_paid_hr);
2954:
2955: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2956: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);

Line 2955: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2951: --
2952: l_hol_days_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2953: fnd_file.put_line(fnd_file.log,'l_hol_days_paid_hr:'||l_hol_days_paid_hr);
2954:
2955: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2956: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);
2957: /*
2958: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2959: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);

Line 2958: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2954:
2955: l_hol_pay_paid_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2956: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid_hr:'||l_hol_pay_paid_hr);
2957: /*
2958: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2959: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);
2960:
2961: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2962: fnd_file.put_line(fnd_file.log,'l_hrly_hol_days_hr:'||l_hrly_hol_days_hr);

Line 2961: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

2957: /*
2958: l_hrly_hol_pay_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2959: fnd_file.put_line(fnd_file.log,'l_hrly_hol_pay_hr:'||l_hrly_hol_pay_hr);
2960:
2961: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2962: fnd_file.put_line(fnd_file.log,'l_hrly_hol_days_hr:'||l_hrly_hol_days_hr);
2963: */
2964: --
2965: pay_action_information_api.create_action_information (

Line 3073: l_spl_hol_uni_agr_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3069: IF (l_use_holiday_card ='Y' AND l_uhc_payroll ='Y') AND l_usr_tbl_exist_400 = 'N' THEN
3070:
3071: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION5,'GROSS') = 'NET'
3072: THEN
3073: l_spl_hol_uni_agr_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3074: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_ne_acct:'||l_spl_hol_uni_agr_net_acc);
3075: ELSE
3076: l_spl_hol_uni_agr_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3077: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_gross_acc:'||l_spl_hol_uni_agr_gross_acc);

Line 3076: l_spl_hol_uni_agr_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3072: THEN
3073: l_spl_hol_uni_agr_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3074: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_ne_acct:'||l_spl_hol_uni_agr_net_acc);
3075: ELSE
3076: l_spl_hol_uni_agr_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3077: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_gross_acc:'||l_spl_hol_uni_agr_gross_acc);
3078: END IF;
3079:
3080: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION6,'GROSS') = 'NET'

Line 3082: l_pro_free_ch_ac_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3078: END IF;
3079:
3080: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION6,'GROSS') = 'NET'
3081: THEN
3082: l_pro_free_ch_ac_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3083: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_net_acc:'||l_pro_free_ch_ac_net_acc);
3084: ELSE
3085: l_pro_free_ch_ac_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3086: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_acc:'||l_pro_free_ch_ac_gross_acc);

Line 3085: l_pro_free_ch_ac_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3081: THEN
3082: l_pro_free_ch_ac_net_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3083: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_net_acc:'||l_pro_free_ch_ac_net_acc);
3084: ELSE
3085: l_pro_free_ch_ac_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3086: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_acc:'||l_pro_free_ch_ac_gross_acc);
3087: END IF;
3088:
3089: l_hol_acc_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Days','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

Line 3089: l_hol_acc_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Days','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3085: l_pro_free_ch_ac_gross_acc := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Accrual','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3086: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_acc:'||l_pro_free_ch_ac_gross_acc);
3087: END IF;
3088:
3089: l_hol_acc_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Days','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3090: fnd_file.put_line(fnd_file.log,'l_hol_acc_days:'||l_hol_acc_days);
3091:
3092: l_hol_acc_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Amount','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3093: fnd_file.put_line(fnd_file.log,'l_hol_acc_amt:'||l_hol_acc_amt);

Line 3092: l_hol_acc_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Amount','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3088:
3089: l_hol_acc_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Days','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3090: fnd_file.put_line(fnd_file.log,'l_hol_acc_days:'||l_hol_acc_days);
3091:
3092: l_hol_acc_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Amount','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3093: fnd_file.put_line(fnd_file.log,'l_hol_acc_amt:'||l_hol_acc_amt);
3094:
3095: --Accrual Reporting (Indberetningstype: Optjening)
3096: pay_action_information_api.create_action_information (

Line 3139: l_spl_hol_uni_agr_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3135: );
3136:
3137: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION5,'GROSS') = 'NET'
3138: THEN
3139: l_spl_hol_uni_agr_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3140: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_net_pmt:'||l_spl_hol_uni_agr_net_pmt);
3141: ELSE
3142: l_spl_hol_uni_agr_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3143: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_gross_pmt:'||l_spl_hol_uni_agr_gross_pmt);

Line 3142: l_spl_hol_uni_agr_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3138: THEN
3139: l_spl_hol_uni_agr_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3140: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_net_pmt:'||l_spl_hol_uni_agr_net_pmt);
3141: ELSE
3142: l_spl_hol_uni_agr_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Special Holiday Union Agreement Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3143: fnd_file.put_line(fnd_file.log,'l_spl_hol_uni_agr_gross_pmt:'||l_spl_hol_uni_agr_gross_pmt);
3144: END IF;
3145:
3146: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION6,'GROSS') = 'NET'

Line 3148: l_pro_free_ch_ac_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3144: END IF;
3145:
3146: IF NVL(rg_Legal_Emp_DA_Codes.ORG_INFORMATION6,'GROSS') = 'NET'
3147: THEN
3148: l_pro_free_ch_ac_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3149: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_net_pmt:'||l_pro_free_ch_ac_net_pmt);
3150: ELSE
3151: l_pro_free_ch_ac_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3152: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_pmt:'||l_pro_free_ch_ac_gross_pmt);

Line 3151: l_pro_free_ch_ac_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3147: THEN
3148: l_pro_free_ch_ac_net_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3149: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_net_pmt:'||l_pro_free_ch_ac_net_pmt);
3150: ELSE
3151: l_pro_free_ch_ac_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3152: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_pmt:'||l_pro_free_ch_ac_gross_pmt);
3153: END IF;
3154:
3155: l_hol_days_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

Line 3155: l_hol_days_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3151: l_pro_free_ch_ac_gross_pmt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Profit From Free Choice Account Payment','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3152: fnd_file.put_line(fnd_file.log,'l_pro_free_ch_ac_gross_pmt:'||l_pro_free_ch_ac_gross_pmt);
3153: END IF;
3154:
3155: l_hol_days_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3156: fnd_file.put_line(fnd_file.log,'l_hol_days_paid:'||l_hol_days_paid);
3157:
3158: l_hol_pay_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3159: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid:'||l_hol_pay_paid);

Line 3158: l_hol_pay_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);

3154:
3155: l_hol_days_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Days Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3156: fnd_file.put_line(fnd_file.log,'l_hol_days_paid:'||l_hol_days_paid);
3157:
3158: l_hol_pay_paid := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Pay Paid','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3159: fnd_file.put_line(fnd_file.log,'l_hol_pay_paid:'||l_hol_pay_paid);
3160:
3161: IF l_start_date >= to_date('01-01-'||to_char(l_start_date,'RRRR'),'dd-mm-rrrr') AND
3162: l_start_date <= to_date('30-04-'||to_char(l_start_date,'RRRR'),'dd-mm-rrrr')