APPS.PAY_IN_EXC dependencies on FND_DATE

Line 616: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');

612: ELSIF p_dimension_name LIKE '%YTD' THEN
613: p_expiry_information := next_tax_year ( p_owner_effective_date) - 1 ;
614: /* Changes for 3839878 Start */
615: ELSIF p_dimension_name LIKE '%LTD' THEN
616: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
617: /* Changes for 3839878 End */
618: ELSE
619: hr_utility.set_message(801,'NO_EXP_CHECK_FOR_DIMENSION');
620: hr_utility.raise_error;

Line 791: AND p_effective_date BETWEEN fnd_date.canonical_to_date(target.org_information3)

787: AND assign.business_group_id = target.organization_id
788: AND target.org_information_context = 'PER_IN_PT_FREQUENCY'
789: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
790: AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = target.org_information1
791: AND p_effective_date BETWEEN fnd_date.canonical_to_date(target.org_information3)
792: AND fnd_date.canonical_to_date(nvl(target.org_information4,'4712/12/31 00:00:00'));
793:
794: BEGIN
795: g_debug := hr_utility.debug_enabled;

Line 792: AND fnd_date.canonical_to_date(nvl(target.org_information4,'4712/12/31 00:00:00'));

788: AND target.org_information_context = 'PER_IN_PT_FREQUENCY'
789: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
790: AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = target.org_information1
791: AND p_effective_date BETWEEN fnd_date.canonical_to_date(target.org_information3)
792: AND fnd_date.canonical_to_date(nvl(target.org_information4,'4712/12/31 00:00:00'));
793:
794: BEGIN
795: g_debug := hr_utility.debug_enabled;
796: l_procedure := g_package ||'get_td_start';