APPS.PAYUSUNB_PKG dependencies on FND_DATE

Line 31: 03-DEC-1999 mcpham 115.1 Added fnd_date.canonical_to_date

27: -----------
28: Date Name Bug No Vers Description
29: ----------- --------- -------- ----- -----------------------------------
30: 29-SEP-1999 mcpham 110.0 created
31: 03-DEC-1999 mcpham 115.1 Added fnd_date.canonical_to_date
32: 05-JAN-2000 mcpham 115.2 converted latest file from release 11.0
33: 22-AUG-2001 tmehra 1158217 115.3 Added new function to check if
34: an employee is Medicare Exempt
35: 1709095 Added Generic Pre-Tax enhancements

Line 260: select fnd_date.date_to_canonical(ld_cur_date)

256: elsif lv_b_dim ='YTD' then
257: ld_cur_date := TRUNC(ld_effective_date, 'Y');
258: end if;
259:
260: select fnd_date.date_to_canonical(ld_cur_date)
261: into lv_cur_date
262: from dual;
263:
264: -- range cursor query

Line 277: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')

273: pay_payroll_actions pa1,
274: pay_assignment_actions act,
275: per_assignments_f paf
276: WHERE ppa.payroll_action_id = :payroll_action_id
277: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')
278: AND pa1.effective_date <= ppa.effective_date
279: AND pa1.payroll_action_id = act.payroll_action_id
280: AND paf.assignment_id = act.assignment_id
281: AND pa1.effective_date BETWEEN paf.effective_start_date