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_GET_ASG_POS dependencies on PER_ALL_ASSIGNMENTS_F

Line 16: from per_all_assignments_f x

12:
13: cursor c1 is
14: select effective_start_date,
15: effective_end_date
16: from per_all_assignments_f x
17: where p_assignment_id = x.assignment_id
18: and p_position_id = x.position_id
19: and p_effective_start_date >= x.effective_start_date
20: order by x.effective_start_date desc;

Line 50: from per_all_assignments_f asg

46: -- Get the start and end dates of rows >= the row passed in
47: cursor c1 is
48: select asg.effective_start_date,
49: asg.effective_end_date
50: from per_all_assignments_f asg
51: ,per_assignment_status_types past
52: where p_assignment_id = assignment_id
53: and p_position_id = position_id
54: and p_effective_start_date <= effective_start_date

Line 61: from per_all_assignments_f

57: -- start changes for 8357127
58: and assignment_type in (
59: -- added in 12631799
60: select assignment_type
61: from per_all_assignments_f
62: where assignment_id = p_assignment_id
63: and p_effective_start_date between effective_start_date and effective_end_date
64: )
65: -- end changes for 8357127