DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on FND_DATE

Line 573: l_cont_service_date := fnd_date.canonical_to_date(l_csd_screen_value);

569: hr_utility.set_location('get_accrual',51);
570: l_cont_service_date := l_service_start_date;
571: ELSE
572: hr_utility.set_location('get_accrual',52);
573: l_cont_service_date := fnd_date.canonical_to_date(l_csd_screen_value);
574: END IF;
575: --
576: -- The "p_param_first..." variables determine when accrual begins for this
577: -- plan and assignment. Accrual begins according to "Accrual Start Rule" and

Line 616: if months_between (fnd_date.canonical_to_date(l_csd_screen_value),p_calculation_date) < 12 then

612: -- 14022134
613:
614: -- Fix for the bug 14837603
615: -- l_temp_date := TRUNC(ADD_MONTHS(l_cont_service_date,12),'YEAR');
616: if months_between (fnd_date.canonical_to_date(l_csd_screen_value),p_calculation_date) < 12 then
617: l_temp_date := TRUNC(ADD_MONTHS(l_cont_service_date,12),'YEAR');
618: hr_utility.set_location('get_accrual :l_temp_date' ||l_temp_date,821);
619:
620: ELSE

Line 712: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +

708: l_temp_date := ADD_MONTHS(l_cont_service_date,
709: (l_inelig_p_length * 2));
710: ELSIF l_inelig_period = 'F'
711: THEN
712: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
713: (l_inelig_p_length * 14),'YYYY/MM/DD'));
714: ELSIF l_inelig_period = 'CM'
715: THEN
716: l_temp_date := ADD_MONTHS(l_cont_service_date,

Line 720: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +

716: l_temp_date := ADD_MONTHS(l_cont_service_date,
717: l_inelig_p_length);
718: ELSIF l_inelig_period = 'LM'
719: THEN
720: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
721: (l_inelig_p_length * 28),'YYYY/MM/DD'));
722: ELSIF l_inelig_period = 'Q'
723: THEN
724: l_temp_date := ADD_MONTHS(l_cont_service_date,

Line 736: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +

732: l_temp_date := ADD_MONTHS(l_cont_service_date,
733: (l_inelig_p_length * 6));
734: ELSIF l_inelig_period = 'W'
735: THEN
736: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
737: (l_inelig_p_length * 7),'YYYY/MM/DD'));
738: ELSIF l_inelig_period = 'Y'
739: THEN
740: l_temp_date := ADD_MONTHS(l_cont_service_date,