APPS.PY_DK_TAX_CARD dependencies on FND_DATE

Line 118: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN

114: pay_input_values_f iv
115: WHERE et.element_name = 'Tax Card'
116: AND et.legislation_code = 'DK'
117: AND et.business_group_id is null
118: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
119: et.effective_start_date AND et.effective_end_date
120: AND iv.element_type_id = et.element_type_id
121: AND fnd_date.canonical_to_date(p_effective_date)
122: BETWEEN iv.effective_start_date AND iv.effective_end_date

Line 121: AND fnd_date.canonical_to_date(p_effective_date)

117: AND et.business_group_id is null
118: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
119: et.effective_start_date AND et.effective_end_date
120: AND iv.element_type_id = et.element_type_id
121: AND fnd_date.canonical_to_date(p_effective_date)
122: BETWEEN iv.effective_start_date AND iv.effective_end_date
123: GROUP BY
124: et.element_type_id;
125: l_proc varchar2(72) := g_package||'insert_taxcard';

Line 226: /*fnd_date_to_canonical removed */

222: ,p_entry_value6 => p_biweekly_td
223: ,p_entry_value7 => p_weekly_td
224: ,p_entry_value8 => p_daily_td
225: /* Modified for bug fix 4604457 */
226: /*fnd_date_to_canonical removed */
227: ,p_entry_value9 => (p_registration_date)
228: ,p_entry_value10 => (p_date_returned)
229: ,p_entry_value11 => 'UPLOAD COMPLETE' /*Added for the tax card requisition enhacement*/
230: ,p_effective_start_date => l_start_date