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 337: select fnd_date.date_to_canonical(ld_cur_date)

333: elsif lv_b_dim ='YTD' then
334: ld_cur_date := TRUNC(ld_effective_date, 'Y');
335: end if;
336:
337: select fnd_date.date_to_canonical(ld_cur_date)
338: into lv_cur_date
339: from dual;
340:
341: -- range cursor query

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

350: pay_payroll_actions pa1,
351: pay_assignment_actions act,
352: per_assignments_f paf
353: WHERE ppa.payroll_action_id = :payroll_action_id
354: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')
355: AND pa1.effective_date <= ppa.effective_date
356: AND pa1.payroll_action_id = act.payroll_action_id
357: AND paf.assignment_id = act.assignment_id
358: AND pa1.effective_date BETWEEN paf.effective_start_date