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.PER_ASG_BUS1 dependencies on PER_PERIODS_OF_SERVICE

Line 5132: , per_periods_of_service ppos

5128: select null
5129: from sys.dual
5130: where exists(select null
5131: from per_all_assignments_f pas
5132: , per_periods_of_service ppos
5133: where pas.effective_start_date <= p_effective_date
5134: and ppos.period_of_service_id = pas.period_of_service_id
5135: and pas.person_id = p_person_id
5136: and pas.primary_flag = 'N'

Line 5139: , per_periods_of_service ppos2

5135: and pas.person_id = p_person_id
5136: and pas.primary_flag = 'N'
5137: and (exists(select null
5138: from per_all_assignments_f pas2
5139: , per_periods_of_service ppos2
5140: where pas2.effective_end_date =
5141: nvl(ppos2.actual_termination_date, hr_api.g_eot)
5142: and pas.assignment_id = pas2.assignment_id
5143: and pas2.period_of_service_id = ppos2.period_of_service_id ))); -- Added this last filter for Bug 4300591.