DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on FND_DATE

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

563: hr_utility.set_location('get_accrual',51);
564: l_cont_service_date := l_service_start_date;
565: ELSE
566: hr_utility.set_location('get_accrual',52);
567: l_cont_service_date := fnd_date.canonical_to_date(l_csd_screen_value);
568: END IF;
569: --
570: -- The "p_param_first..." variables determine when accrual begins for this
571: -- plan and assignment. Accrual begins according to "Accrual Start Rule" and

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

662: l_temp_date := ADD_MONTHS(l_cont_service_date,
663: (l_inelig_p_length * 2));
664: ELSIF l_inelig_period = 'F'
665: THEN
666: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
667: (l_inelig_p_length * 14),'YYYY/MM/DD'));
668: ELSIF l_inelig_period = 'CM'
669: THEN
670: l_temp_date := ADD_MONTHS(l_cont_service_date,

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

670: l_temp_date := ADD_MONTHS(l_cont_service_date,
671: l_inelig_p_length);
672: ELSIF l_inelig_period = 'LM'
673: THEN
674: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
675: (l_inelig_p_length * 28),'YYYY/MM/DD'));
676: ELSIF l_inelig_period = 'Q'
677: THEN
678: l_temp_date := ADD_MONTHS(l_cont_service_date,

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

686: l_temp_date := ADD_MONTHS(l_cont_service_date,
687: (l_inelig_p_length * 6));
688: ELSIF l_inelig_period = 'W'
689: THEN
690: l_temp_date := fnd_date.canonical_to_date(to_char(l_cont_service_date +
691: (l_inelig_p_length * 7),'YYYY/MM/DD'));
692: ELSIF l_inelig_period = 'Y'
693: THEN
694: l_temp_date := ADD_MONTHS(l_cont_service_date,