APPS.PAY_GB_RTI_EYU dependencies on FND_DATE

Line 198: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

194: WHERE addr.person_id = p_person_id
195: AND ( addr.primary_flag = 'Y'
196: OR addr.primary_flag IS NULL)
197: AND p_effective_date
198: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
199: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
200:
201: l_addr_rec csr_address%rowtype;
202:

Line 199: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));

195: AND ( addr.primary_flag = 'Y'
196: OR addr.primary_flag IS NULL)
197: AND p_effective_date
198: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
199: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
200:
201: l_addr_rec csr_address%rowtype;
202:
203: BEGIN

Line 1318: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)

1314:
1315: -- Cursor to fetch the RTI NI Reporting assignment for this person.
1316: cursor csr_get_ni_rpt_asg(c_asg_id number) is
1317: select
1318: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
1319: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
1320: pay_all_payrolls_f pay,
1321: hr_soft_coding_keyflex sck
1322: where paaf1.assignment_id = c_asg_id

Line 3597: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));

3593: else
3594: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
3595: end if;
3596:
3597: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
3598:
3599: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
3600:
3601: l_date_valid := p_validate_date;

Line 4130: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)

4126:
4127: -- Cursor to fetch the RTI NI Reporting assignment for this person.
4128: cursor csr_get_ni_rpt_asg(c_asg_id number) is
4129: select
4130: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
4131: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
4132: pay_all_payrolls_f pay,
4133: hr_soft_coding_keyflex sck
4134: where paaf1.assignment_id = c_asg_id

Line 6055: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN

6051: OPEN get_person_details(action_id.assignment_id);
6052: FETCH get_person_details INTO et_asg_rec;
6053: CLOSE get_person_details;
6054: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
6055: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
6056: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
6057: || rpad(l_et_temp,50) );
6058: ELSE
6059: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '

Line 6085: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN

6081:
6082: l_error_flag := 'Y';
6083:
6084: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
6085: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
6086: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
6087: || ' ' || rpad(err_msg,120) ); -- error message
6088: ELSE
6089: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)