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.

[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_POSITION_EXTRA_INFO

Line 7398: from per_position_extra_info

7394: /*- This cursor added for the bug 5840410 --*/
7395:
7396: cursor c1 is
7397: select 'x'
7398: from per_position_extra_info
7399: where position_id= p_position_id
7400: and information_type = 'PER_OVERLAP';
7401:
7402: -- Start changes for bug 11828317

Line 7406: from per_position_extra_info

7402: -- Start changes for bug 11828317
7403: cursor c2 is
7404:
7405: /* select 'x'
7406: from per_position_extra_info
7407: where p_assignment_start_date
7408: between fnd_date.canonical_to_date(poei_information3)
7409: and fnd_date.canonical_to_date(poei_information4)
7410: -- Start changes for bug 10220040

Line 7423: from per_position_extra_info

7419: fnd_date.canonical_to_date(poei_information3) effective_start_date,
7420: nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr')) effective_end_date
7421: from (
7422: select poei_information3,poei_information4
7423: from per_position_extra_info
7424: where information_type = 'PER_OVERLAP'
7425: and position_id = p_position_id)
7426: where p_assignment_start_date
7427: between fnd_date.canonical_to_date(poei_information3)