eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_EOY_PKG dependencies on FND_DATE

Line 1054: --and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date --12322620

1050: and posv.business_group_id=p_business_group_id
1051: UNION ALL
1052: select p_business_group_id FROM DUAL)
1053: and nvl(p_hr_org_id,organization_id)=organization_id
1054: --and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date --12322620
1055: --12322620
1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)
1057: --13604353
1058: /*AND EXISTS (SELECT 1 from per_all_assignments_f paaf

Line 1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)

1052: select p_business_group_id FROM DUAL)
1053: and nvl(p_hr_org_id,organization_id)=organization_id
1054: --and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date --12322620
1055: --12322620
1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)
1057: --13604353
1058: /*AND EXISTS (SELECT 1 from per_all_assignments_f paaf
1059: where paaf.assignment_id = asg.assignment_id
1060: and fnd_date.canonical_to_date(p_date) -1 BETWEEN paaf.effective_start_date and paaf.effective_end_date

Line 1060: and fnd_date.canonical_to_date(p_date) -1 BETWEEN paaf.effective_start_date and paaf.effective_end_date

1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)
1057: --13604353
1058: /*AND EXISTS (SELECT 1 from per_all_assignments_f paaf
1059: where paaf.assignment_id = asg.assignment_id
1060: and fnd_date.canonical_to_date(p_date) -1 BETWEEN paaf.effective_start_date and paaf.effective_end_date
1061: )*/
1062:
1063: AND EXISTS (SELECT 1 from per_periods_of_service ppos
1064: where ppos.person_id = asg.person_id

Line 1065: AND ppos.DATE_START < fnd_date.canonical_to_date (p_date)

1061: )*/
1062:
1063: AND EXISTS (SELECT 1 from per_periods_of_service ppos
1064: where ppos.person_id = asg.person_id
1065: AND ppos.DATE_START < fnd_date.canonical_to_date (p_date)
1066: AND (ppos.ACTUAL_TERMINATION_DATE IS NULL --Not Terminated
1067: OR nvl(ppos.FINAL_PROCESS_DATE,ppos.ACTUAL_TERMINATION_DATE)
1068: >= fnd_date.canonical_to_date(p_date)) --Terminated in future
1069: )

Line 1068: >= fnd_date.canonical_to_date(p_date)) --Terminated in future

1064: where ppos.person_id = asg.person_id
1065: AND ppos.DATE_START < fnd_date.canonical_to_date (p_date)
1066: AND (ppos.ACTUAL_TERMINATION_DATE IS NULL --Not Terminated
1067: OR nvl(ppos.FINAL_PROCESS_DATE,ppos.ACTUAL_TERMINATION_DATE)
1068: >= fnd_date.canonical_to_date(p_date)) --Terminated in future
1069: )
1070: --13604353
1071: --12322620
1072: and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 1102: l_st_date := fnd_date.canonical_to_date(p_date); --12322620

1098: --hr_utility.trace_on(null,'RESET_OVERRIDE');
1099: --hr_utility.trace('In reset override');
1100:
1101: retcode := 0;
1102: l_st_date := fnd_date.canonical_to_date(p_date); --12322620
1103:
1104: --------------------------------------------------------------------
1105: --Loop through all assignments and update them
1106: --------------------------------------------------------------------

Line 1110: --if l_asg_details.effective_start_date = fnd_date.canonical_to_date(p_date) then --12322620

1106: --------------------------------------------------------------------
1107: for l_asg_details in csr_get_asg_details(p_hr_org_id,p_date,p_org_struct_id,p_business_group_id) loop
1108: l_object_version_number := l_asg_details.object_version_number ;
1109: l_asg_st_date := GREATEST(l_asg_details.effective_start_date, l_st_date); --12322620
1110: --if l_asg_details.effective_start_date = fnd_date.canonical_to_date(p_date) then --12322620
1111:
1112: --12608988 Start
1113: IF l_last_assignment_id<>l_asg_details.assignment_id THEN
1114: l_max_assignment_end_date:=l_asg_details.effective_end_date;

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

1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:
1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1147: l_soft_coding_keyflex_id := NULL; -- Bug 5763286

Line 1150: --,p_effective_date => fnd_date.canonical_to_date(p_date) --12322620

1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1147: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1148: hr_nl_assignment_api.update_nl_emp_asg
1149: (p_validate => FALSE
1150: --,p_effective_date => fnd_date.canonical_to_date(p_date) --12322620
1151: ,p_effective_date => l_asg_st_date --12322620
1152: ,p_person_id => l_asg_details.person_id
1153: ,p_datetrack_update_mode => l_datetrack_update_mode
1154: ,p_assignment_id => l_asg_details.assignment_id