APPS.PAY_JP_DEF_REPORT_PKG dependencies on FND_DATE

Line 264: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')

260: where ppa.payroll_action_id = :payroll_action_id
261: and pp.business_group_id = ppa.business_group_id + 0
262: and ppos.person_id = pp.person_id
263: and ppos.business_group_id + 0 = pp.business_group_id
264: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')
265: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_date'')) >= fnd_date.canonical_to_date(''i_effective_date'')
266: order by
267: ppos.person_id';
268: --

Line 265: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_date'')) >= fnd_date.canonical_to_date(''i_effective_date'')

261: and pp.business_group_id = ppa.business_group_id + 0
262: and ppos.person_id = pp.person_id
263: and ppos.business_group_id + 0 = pp.business_group_id
264: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')
265: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_date'')) >= fnd_date.canonical_to_date(''i_effective_date'')
266: order by
267: ppos.person_id';
268: --
269: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));

Line 269: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));

265: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_date'')) >= fnd_date.canonical_to_date(''i_effective_date'')
266: order by
267: ppos.person_id';
268: --
269: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));
270: --
271: if g_debug then
272: hr_utility.set_location(l_proc,1000);
273: end if;