APPS.PAY_MX_YEAREND_REP dependencies on FND_DATE

Line 59: and pai.action_information7 = fnd_date.date_to_canonical(ye_effective_date)

55: and paa.payroll_action_id = ppa.payroll_action_id
56: and paa.serial_number = ye_person_id
57: and pai.action_context_id = paa.assignment_action_id
58: /*and pai.effective_date = ye_effective_date*/
59: and pai.action_information7 = fnd_date.date_to_canonical(ye_effective_date)
60: and fai.context1 = paa.assignment_action_id
61: and fai.archive_item_id = fic.archive_item_id
62: and fai.user_entity_id = fue.user_entity_id
63: and fic.context_id = ffc.context_id

Line 178: and pai.action_information7 = fnd_date.date_to_canonical(p_effective_date) /*Bug 8402505*/

174: pay_action_information pai
175: where paa.payroll_action_id = p_payroll_action_id
176: and paa.serial_number = p_person_id
177: --and pai.effective_date = p_effective_date
178: and pai.action_information7 = fnd_date.date_to_canonical(p_effective_date) /*Bug 8402505*/
179: and pai.action_context_id = paa.assignment_action_id
180: and pai.action_information_category='MX YREND EE DETAILS' ;
181:
182: l_annual_tax_calc_flag varchar2(1);