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 PER_ASSIGNMENT_STATUS_TYPES

Line 5253: from per_all_assignments_f asg, per_assignment_status_types ast

5249: --
5250: -- Start changes for bug 13519283
5251: cursor c_no_assignments(p_position_id number, p_effective_date date) is
5252: select asg.assignment_id, asg.effective_start_date, asg.effective_end_date
5253: from per_all_assignments_f asg, per_assignment_status_types ast
5254: where asg.position_id = p_position_id
5255: and (asg.effective_start_date >= p_effective_date
5256: or p_effective_date between asg.effective_start_date and asg.effective_end_date) -- Added for Bug#14022433
5257: and asg.assignment_type in ('E', 'C')

Line 5268: per_assignment_status_types ast

5264: asg.effective_start_date,
5265: asg.effective_end_date
5266: from
5267: per_all_assignments_f asg,
5268: per_assignment_status_types ast
5269: where asg.assignment_id <> lp_asg_id
5270: and asg.position_id = p_position_id
5271: and (lp_asg_start_date between asg.effective_start_date and asg.effective_end_date
5272: or