APPS.PAY_GB_RTI dependencies on FND_DATE

Line 225: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

221: from per_addresses addr
222: where addr.person_id = p_person_id
223: and ( addr.primary_flag = 'Y'
224: or addr.primary_flag is null)
225: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
226: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
227:
228:
229: l_addr_rec csr_address%rowtype;

Line 226: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));

222: where addr.person_id = p_person_id
223: and ( addr.primary_flag = 'Y'
224: or addr.primary_flag is null)
225: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
226: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
227:
228:
229: l_addr_rec csr_address%rowtype;
230:

Line 682: if l_final_eff_end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then

678: fetch csr_get_irregular_details into l_irregular_emp_ind;
679: close csr_get_irregular_details;
680:
681: -- if end date is 31 Dec 4712 make it as null
682: if l_final_eff_end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
683: l_final_eff_end_date := null;
684: End if;
685:
686: --if Termination Date is in future make it as null

Line 2400: l_eff_date := fnd_date.canonical_to_date(l_eff_temp_date);

2396: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2397: p_payroll_action_id => l_pact_id,
2398: p_token_name => 'START',
2399: p_token_value => l_eff_temp_date);
2400: l_eff_date := fnd_date.canonical_to_date(l_eff_temp_date);
2401:
2402: END IF;
2403: l_effective_date := p_effective_date; -- For NINO
2404:

Line 3024: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then

3020: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' ||
3021: asg_rec.f_name || ' ' || asg_rec.m_name;
3022:
3023: if report_type = 'RTI_EAS_REP' then
3024: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3025: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3026: rpad(asg_rec.ni_no ,10) || ' ' ||
3027: rpad(l_temp,50) || ' ' ||
3028: rpad(asg_rec.start_date,15) || ' ' ||

Line 3204: ,argument5 => fnd_date.date_to_canonical(sysdate)

3200: ,argument1 => 'ARCHIVE' --Process Name
3201: ,argument2 => 'RTI_NINO_OUTPUT'
3202: ,argument3 => 'GB'
3203: ,argument4 => '0001/01/01 00:00:00'
3204: ,argument5 => fnd_date.date_to_canonical(sysdate)
3205: ,argument6 => 'XML'
3206:
3207: ,argument7 => l_payroll_rec.bus_grp_id
3208: ,argument8 => null --Magnetic File Name

Line 3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)

3239:
3240:
3241: cursor csr_parameter_info is
3242: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
3244: from pay_payroll_actions ppa
3245: ,pay_assignment_actions paa
3246: where paa.assignment_action_id = c_assignment_action_id
3247: and ppa.payroll_action_id = paa.payroll_action_id;

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

3268: else
3269: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
3270: end if;
3271:
3272: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
3273:
3274: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
3275:
3276: l_date_valid := p_validate_date;