APPS.PAY_GB_RTI_EAS dependencies on FND_DATE

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

165: from per_addresses addr
166: where addr.person_id = p_person_id
167: and ( addr.primary_flag = 'Y'
168: or addr.primary_flag is null)
169: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
170: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
171:
172:
173: l_addr_rec csr_address%rowtype;

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

166: where addr.person_id = p_person_id
167: and ( addr.primary_flag = 'Y'
168: or addr.primary_flag is null)
169: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
170: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
171:
172:
173: l_addr_rec csr_address%rowtype;
174:

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

1065:
1066: l_pay_non_indiv_ind := get_pay_non_indiv_ind(p_person_rec.assignment_id,l_business_group_id,l_effective_start_date);
1067:
1068: -- if end date is 31 Dec 4712 make it as null
1069: if l_final_eff_end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
1070: l_final_eff_end_date := null;
1071: End if;
1072:
1073: --if Termination Date is in future make it as null

Line 2190: if l_payroll_rec.effective_date < fnd_date.canonical_to_date('2013/04/06 00:00:00') then

2186: hr_utility.set_location('Calling header validations', 10);
2187:
2188: /* EAS 2013 Changes*/
2189:
2190: if l_payroll_rec.effective_date < fnd_date.canonical_to_date('2013/04/06 00:00:00') then
2191: hr_utility.set_location('Effective Date must be later than 06-April-2013',10);
2192: fnd_file.put_line(fnd_file.output,'Effective Date must be later than 06-April-2013.');
2193: l_err := true;
2194: end if;

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

3118: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
3119: p_payroll_action_id => l_pact_id,
3120: p_token_name => 'START',
3121: p_token_value => l_eff_temp_date);
3122: l_eff_date := fnd_date.canonical_to_date(l_eff_temp_date);
3123:
3124: END IF;
3125: l_effective_date := p_effective_date; -- For NINO
3126:

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

3856: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' ||
3857: asg_rec.f_name || ' ' || asg_rec.m_name;
3858:
3859: if report_type = 'RTI_EAS_REP_13' then
3860: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3861: -- if asg_rec.end_date = '31-DEC-4712' then
3862: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3863: rpad(asg_rec.ni_no ,10) || ' ' ||
3864: rpad(l_temp,50) || ' ' ||

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

3919: IF csr_war_msg%NOTFOUND THEN
3920: NULL;
3921: ELSE
3922: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
3923: if asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') then
3924:
3925: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3926: rpad(asg_rec.ni_no ,10) || ' ' ||
3927: rpad(l_temp,50) || ' ' ||

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

4097: ,argument1 => 'ARCHIVE' --Process Name
4098: ,argument2 => 'RTI_NINO_OUTPUT'
4099: ,argument3 => 'GB'
4100: ,argument4 => '0001/01/01 00:00:00'
4101: ,argument5 => fnd_date.date_to_canonical(sysdate)
4102: ,argument6 => 'XML'
4103:
4104: ,argument7 => l_payroll_rec.bus_grp_id
4105: ,argument8 => null --Magnetic File Name

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

4136:
4137:
4138: cursor csr_parameter_info is
4139: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
4140: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
4141: from pay_payroll_actions ppa
4142: ,pay_assignment_actions paa
4143: where paa.assignment_action_id = c_assignment_action_id
4144: and ppa.payroll_action_id = paa.payroll_action_id;

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

4164: else
4165: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
4166: end if;
4167:
4168: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
4169:
4170: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
4171:
4172: l_date_valid := p_validate_date;