DBA Data[Home] [Help]

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