APPS.PY_NO_TAX_CARD dependencies on FND_DATE

Line 109: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN

105: pay_input_values_f iv
106: WHERE et.element_name = 'Tax Card'
107: AND et.legislation_code = 'NO'
108: AND et.business_group_id is null
109: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
110: et.effective_start_date AND et.effective_end_date
111: AND iv.element_type_id = et.element_type_id
112: AND fnd_date.canonical_to_date(p_effective_date)
113: BETWEEN iv.effective_start_date AND iv.effective_end_date

Line 112: AND fnd_date.canonical_to_date(p_effective_date)

108: AND et.business_group_id is null
109: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
110: et.effective_start_date AND et.effective_end_date
111: AND iv.element_type_id = et.element_type_id
112: AND fnd_date.canonical_to_date(p_effective_date)
113: BETWEEN iv.effective_start_date AND iv.effective_end_date
114: GROUP BY
115: et.element_type_id;
116: l_proc varchar2(72) := g_package||'insert_taxcard';

Line 148: fnd_date.date_to_canonical(p_effective_date),

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

Line 201: /*fnd_date_to_canonical removed */

197: ,p_entry_value4 => l_entry_value4
198: ,p_entry_value5 => p_entry_value5
199: ,p_entry_value6 => p_entry_value6
200: ,p_entry_value7 => p_entry_value7
201: /*fnd_date_to_canonical removed */
202: ,p_entry_value8 => (p_entry_value8)
203: ,p_entry_value9 => (p_entry_value9)
204: ,p_effective_start_date => l_start_date
205: ,p_effective_end_date => l_end_date