APPS.PAY_GB_MOVDED_EDI dependencies on FND_DATE

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

803: from per_addresses addr
804: where addr.person_id(+) = p_person_id
805: and ( addr.primary_flag = 'Y'
806: or addr.primary_flag is null)
807: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
808: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
809: l_addr_rec csr_address%rowtype;
810: BEGIN
811: hr_utility.set_location('Entering: '||l_proc,1);

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

804: where addr.person_id(+) = p_person_id
805: and ( addr.primary_flag = 'Y'
806: or addr.primary_flag is null)
807: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
808: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
809: l_addr_rec csr_address%rowtype;
810: BEGIN
811: hr_utility.set_location('Entering: '||l_proc,1);
812: l_arch := true;

Line 904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,

900: pap.middle_names,
901: paa.ASSIGNMENT_NUMBER,
902: pap.national_identifier,
903: pap.sex,
904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
906: from pay_assignment_actions act,
907: per_assignments_f paa,
908: per_people_f pap,

Line 905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date

901: paa.ASSIGNMENT_NUMBER,
902: pap.national_identifier,
903: pap.sex,
904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
906: from pay_assignment_actions act,
907: per_assignments_f paa,
908: per_people_f pap,
909: per_periods_of_service serv

Line 1041: fnd_date.date_to_canonical(min(decode(inv.name, 'End Date', eev.effective_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00')))) eff_date

1037:
1038: cursor csr_student_loan is
1039: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1040: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1041: fnd_date.date_to_canonical(min(decode(inv.name, 'End Date', eev.effective_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00')))) eff_date
1042: from pay_element_types_f elt,
1043: pay_element_entries_f ele,
1044: pay_input_values_f inv,
1045: pay_element_entry_values_f eev

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

2003: else
2004: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
2005: end if;
2006:
2007: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
2008:
2009: l_tax_year_start := add_months(l_tax_date,-12)+1 ; -- 6804206
2010:
2011: l_date_valid := p_validate_date;