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.HR_PSF_BUS dependencies on FND_DATE

Line 4847: between fnd_date.canonical_to_date(poei_information3)

4843: from per_position_extra_info
4844: where position_id = p_position_id
4845: and information_type= 'PER_RESERVED'
4846: and p_effective_date
4847: between fnd_date.canonical_to_date(poei_information3)
4848: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
4849: --
4850: cursor csr_valid_eff_date(p_position_id number,
4851: p_validation_start_date date,

Line 4848: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

4844: where position_id = p_position_id
4845: and information_type= 'PER_RESERVED'
4846: and p_effective_date
4847: between fnd_date.canonical_to_date(poei_information3)
4848: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
4849: --
4850: cursor csr_valid_eff_date(p_position_id number,
4851: p_validation_start_date date,
4852: p_validation_end_date date) is

Line 4863: from (select fnd_date.canonical_to_date(poei_information3) start_date

4859: and p_validation_end_date
4860: and position_id = p_position_id
4861: union
4862: select start_date
4863: from (select fnd_date.canonical_to_date(poei_information3) start_date
4864: from per_position_extra_info
4865: where position_id = p_position_id
4866: and information_type = 'PER_RESERVED') a
4867: where a.start_date between p_validation_start_date and p_validation_end_date;