DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PAY_BALANCE_PKG

Line 410: l_holiday_ent_days := pay_balance_pkg.get_value(l_holiday_ent,csr_he.assignment_id,g_effective_date);

406: LOOP
407:
408:
409: Begin
410: l_holiday_ent_days := pay_balance_pkg.get_value(l_holiday_ent,csr_he.assignment_id,g_effective_date);
411: Exception
412: When others then
413: l_holiday_ent_days := 0;
414: END;

Line 417: l_holiday_ent_60_days := pay_balance_pkg.get_value(l_holiday_ent_60,csr_he.assignment_id,g_effective_date);

413: l_holiday_ent_days := 0;
414: END;
415:
416: Begin
417: l_holiday_ent_60_days := pay_balance_pkg.get_value(l_holiday_ent_60,csr_he.assignment_id,g_effective_date);
418: Exception
419: When others then
420: l_holiday_ent_60_days := 0;
421: END;

Line 424: l_holiday_carried_fwd_days := pay_balance_pkg.get_value(l_holiday_carried_fwd,csr_he.assignment_id,g_effective_date);

420: l_holiday_ent_60_days := 0;
421: END;
422:
423: Begin
424: l_holiday_carried_fwd_days := pay_balance_pkg.get_value(l_holiday_carried_fwd,csr_he.assignment_id,g_effective_date);
425: Exception
426: When others then
427: l_holiday_carried_fwd_days := 0;
428: END;

Line 431: l_holiday_carried_od_days := pay_balance_pkg.get_value(l_holiday_carried_od,csr_he.assignment_id,g_effective_date);

427: l_holiday_carried_fwd_days := 0;
428: END;
429:
430: Begin
431: l_holiday_carried_od_days := pay_balance_pkg.get_value(l_holiday_carried_od,csr_he.assignment_id,g_effective_date);
432: Exception
433: When others then
434: l_holiday_carried_od_days := 0;
435: END;

Line 438: l_holiday_taken_days := pay_balance_pkg.get_value(l_holiday_days_taken,csr_he.assignment_id,g_effective_date);

434: l_holiday_carried_od_days := 0;
435: END;
436:
437: Begin
438: l_holiday_taken_days := pay_balance_pkg.get_value(l_holiday_days_taken,csr_he.assignment_id,g_effective_date);
439: Exception
440: When others then
441: l_holiday_taken_days := 0;
442: END;

Line 445: l_holiday_taken_60_days := pay_balance_pkg.get_value(l_holiday_days_taken_60,csr_he.assignment_id,g_effective_date);

441: l_holiday_taken_days := 0;
442: END;
443:
444: Begin
445: l_holiday_taken_60_days := pay_balance_pkg.get_value(l_holiday_days_taken_60,csr_he.assignment_id,g_effective_date);
446: Exception
447: When others then
448: l_holiday_taken_60_days := 0;
449: END;

Line 452: l_holiday_remaining_days := pay_balance_pkg.get_value(l_holiday_day_remaining,csr_he.assignment_id,g_effective_date);

448: l_holiday_taken_60_days := 0;
449: END;
450:
451: Begin
452: l_holiday_remaining_days := pay_balance_pkg.get_value(l_holiday_day_remaining,csr_he.assignment_id,g_effective_date);
453: Exception
454: When others then
455: l_holiday_remaining_days := 0;
456: END;

Line 461: l_holiday_remaining60_days := pay_balance_pkg.get_value(l_holiday_day_remaining60,csr_he.assignment_id,g_effective_date);

457: /* Added for Bug 5391237*/
458: l_holiday_remaining_days := nvl(l_holiday_remaining_days,0) + nvl(l_holiday_carried_od_days,0);
459:
460: Begin
461: l_holiday_remaining60_days := pay_balance_pkg.get_value(l_holiday_day_remaining60,csr_he.assignment_id,g_effective_date);
462: Exception
463: When others then
464: l_holiday_remaining60_days := 0;
465: END;