APPS.PY_SE_TAX_CARD dependencies on FND_DATE

Line 113: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN

109: pay_input_values_f iv
110: WHERE et.element_name = 'Tax Card'
111: AND et.legislation_code = 'SE'
112: AND et.business_group_id is null
113: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
114: et.effective_start_date AND et.effective_end_date
115: AND iv.element_type_id = et.element_type_id
116: AND fnd_date.canonical_to_date(p_effective_date)
117: BETWEEN iv.effective_start_date AND iv.effective_end_date

Line 116: AND fnd_date.canonical_to_date(p_effective_date)

112: AND et.business_group_id is null
113: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
114: et.effective_start_date AND et.effective_end_date
115: AND iv.element_type_id = et.element_type_id
116: AND fnd_date.canonical_to_date(p_effective_date)
117: BETWEEN iv.effective_start_date AND iv.effective_end_date
118: GROUP BY
119: et.element_type_id;
120:

Line 149: fnd_date.date_to_canonical(p_effective_date),

145: hr_utility.set_location( l_proc, 10);
146: -- fetch element link id from Swedish tax upload package
147: l_element_link_id := pay_se_tax_card.get_element_link_id(
148: p_assignment_id, p_business_group_id,
149: fnd_date.date_to_canonical(p_effective_date),
150: 'Tax Card');
151: -- if g_debug then
152: hr_utility.set_location('Entering:'|| l_proc, 2);
153: -- end if;