APPS.PAY_GB_MOVDED_EDI dependencies on FND_DATE

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

993: from per_addresses addr
994: where addr.person_id(+) = p_person_id
995: and ( addr.primary_flag = 'Y'
996: or addr.primary_flag is null)
997: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
998: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
999: l_addr_rec csr_address%rowtype;
1000: BEGIN
1001: hr_utility.set_location('Entering: '||l_proc,1);

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

994: where addr.person_id(+) = p_person_id
995: and ( addr.primary_flag = 'Y'
996: or addr.primary_flag is null)
997: and p_effective_date between nvl(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
998: and nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
999: l_addr_rec csr_address%rowtype;
1000: BEGIN
1001: hr_utility.set_location('Entering: '||l_proc,1);
1002: l_arch := true;

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

1095: pap.middle_names,
1096: paa.ASSIGNMENT_NUMBER,
1097: pap.national_identifier,
1098: pap.sex,
1099: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,

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

1096: paa.ASSIGNMENT_NUMBER,
1097: pap.national_identifier,
1098: pap.sex,
1099: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,
1104: per_periods_of_service serv

Line 1242: 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

1238:
1239: cursor csr_student_loan is
1240: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1241: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1242: 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
1243: from pay_element_types_f elt,
1244: pay_element_entries_f ele,
1245: pay_input_values_f inv,
1246: pay_element_entry_values_f eev

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

3448: else
3449: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
3450: end if;
3451:
3452: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
3453:
3454: l_tax_year_start := add_months(l_tax_date,-12)+1 ; -- 6804206
3455:
3456: l_date_valid := p_validate_date;

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

3569: else
3570: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
3571: end if;
3572:
3573: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
3574:
3575: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
3576:
3577: if l_date_valid < l_tax_year_start then