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

Line 3611: between fnd_date.canonical_to_date(poei_information3)

3607: from per_position_extra_info
3608: where position_id = p_position_id
3609: and information_type= 'PER_RESERVED'
3610: and p_effective_date
3611: between fnd_date.canonical_to_date(poei_information3)
3612: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3613: --
3614: cursor csr_valid_eff_date(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3615: select p_validation_start_date start_date

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

3608: where position_id = p_position_id
3609: and information_type= 'PER_RESERVED'
3610: and p_effective_date
3611: between fnd_date.canonical_to_date(poei_information3)
3612: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3613: --
3614: cursor csr_valid_eff_date(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3615: select p_validation_start_date start_date
3616: from dual

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

3615: select p_validation_start_date start_date
3616: from dual
3617: union
3618: select start_date
3619: from (select fnd_date.canonical_to_date(poei_information3) start_date
3620: from per_position_extra_info
3621: where position_id = p_position_id
3622: and information_type = 'PER_RESERVED') a
3623: where a.start_date between p_validation_start_date and p_validation_end_date;