APPS.PER_BULK_APP_ASG_CHANGE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 34: from per_all_assignments_f

30: -- application which is not the current assignment.
31: --
32: cursor c1 is
33: select max(effective_end_date)
34: from per_all_assignments_f
35: where person_id = p_person_id
36: and application_id = p_application_id
37: and assignment_id <> p_assignment_id
38: and assignment_type = 'A' ;

Line 67: from per_all_assignments_f a,

63: procedure chk_future_asg_changes ( p_assignment_id in number ) is
64: l_dummy number ;
65: cursor c1 is
66: select 1
67: from per_all_assignments_f a,
68: fnd_sessions f
69: where a.assignment_id = p_assignment_id
70: and f.session_id = userenv('sessionid')
71: and a.effective_start_date > f.effective_date ;

Line 115: from per_all_assignments_f

111: l_asg_max_end_date date ;
112: -- Retrieve latest end date of assignment
113: cursor c1 is
114: select max(effective_end_date)
115: from per_all_assignments_f
116: where assignment_id = p_assignment_id ;
117: begin
118: --
119: open c1 ;

Line 167: -- from per_all_assignments_f

163: -- Commented out as part of fix for bug 677744. This cursor is no longer
164: -- required.
165: -- cursor c4 is
166: -- select min(effective_start_date) - 1
167: -- from per_all_assignments_f
168: -- where assignment_id = p_assignment_id ;
169: -- End of this part of fix.
170: --
171: begin

Line 332: from per_all_assignments_f a

328: p_assignment_id in number,
329: p_effective_date in date ) return date is
330: cursor c1 is
331: select nvl(max(a.effective_end_date),p_effective_date)
332: from per_all_assignments_f a
333: where a.person_id = p_person_id
334: and a.application_id = p_application_id
335: and a.assignment_id <> p_assignment_id
336: and a.assignment_type = 'A'

Line 459: From per_all_assignments_f

455: p_validation_start_date in date) is
456:
457: cursor csr_vacancy_id is
458: Select vacancy_id
459: From per_all_assignments_f
460: Where assignment_id = p_assignment_id
461: And p_effective_date between effective_start_date and effective_end_date;
462:
463: l_vacancy_id number;

Line 516: update per_all_assignments_f

512: if ( p_status_changed and p_new_system_status = 'TERM_APL' ) then
513: l_end_row := 'TRUE' ;
514: end if ;
515: --
516: update per_all_assignments_f
517: set assignment_status_type_id = decode( l_end_row,
518: 'TRUE',
519: assignment_status_type_id,
520: p_new_asg_status_type_id ),