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 ;
72: begin
143: --
144: cursor c1 is
145: select f.effective_date
146: from per_people_f p,
147: fnd_sessions f
148: where p.person_id = p_person_id
149: and p.effective_start_date > f.effective_date
150: and f.session_id = userenv('sessionid') ;
151: --
152: --
153: -- Retrieve the effective date
154: cursor c3 is
155: select effective_date
156: from fnd_sessions
157: where session_id = userenv('sessionid');
158: --
159: --
160: -- This cursor retrieves the day before the earliest start date for