DBA Data[Home] [Help]

APPS.PER_BULK_APP_ASG_CHANGE_PKG dependencies on FND_SESSIONS

Line 68: fnd_sessions f

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

Line 147: fnd_sessions f

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: --

Line 156: from fnd_sessions

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