APPS.PAY_NL_EOY_PKG dependencies on FND_DATE

Line 1002: and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date

998: and posv.business_group_id=p_business_group_id
999: UNION ALL
1000: select p_business_group_id FROM DUAL)
1001: and nvl(p_hr_org_id,organization_id)=organization_id
1002: and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date
1003: and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1004: and scl.segment12 is not null
1005: and ast.assignment_status_type_id = asg.assignment_status_type_id
1006: and asg.business_group_id = p_business_group_id

Line 1023: if l_asg_details.effective_start_date = fnd_date.canonical_to_date(p_date) then

1019: --Loop through all assignments and update them
1020: --------------------------------------------------------------------
1021: for l_asg_details in csr_get_asg_details(p_hr_org_id,p_date,p_org_struct_id,p_business_group_id) loop
1022: l_object_version_number := l_asg_details.object_version_number ;
1023: if l_asg_details.effective_start_date = fnd_date.canonical_to_date(p_date) then
1024: l_datetrack_update_mode := 'CORRECTION';
1025: elsif
1026: l_asg_details.effective_end_date <> hr_general.end_of_time then
1027: l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';

Line 1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));

1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);
1039:
1040: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1041: l_soft_coding_keyflex_id := NULL; -- Bug 5763286

Line 1044: ,p_effective_date => fnd_date.canonical_to_date(p_date)

1040: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1041: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1042: hr_nl_assignment_api.update_nl_emp_asg
1043: (p_validate => FALSE
1044: ,p_effective_date => fnd_date.canonical_to_date(p_date)
1045: ,p_person_id => l_asg_details.person_id
1046: ,p_datetrack_update_mode => l_datetrack_update_mode
1047: ,p_assignment_id => l_asg_details.assignment_id
1048: ,p_object_version_number => l_object_version_number