APPS.GHR_CPDF_STATRPT dependencies on FND_SESSIONS

Line 141: INSERT INTO fnd_sessions

137: PPP.DATE_START = (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1 WHERE PPP1.PERSON_ID = PER.PERSON_ID AND
138: PPP1.DATE_START <= PER.EFFECTIVE_END_DATE)));
139:
140: BEGIN
141: INSERT INTO fnd_sessions
142: (session_id
143: ,effective_date)
144: VALUES
145: (userenv('sessionid')

Line 153: DELETE FROM fnd_sessions

149: FOR cur_per_rec IN cur_per LOOP
150: p_appointment_date := cur_per_rec.hire_date;
151: END LOOP;
152:
153: DELETE FROM fnd_sessions
154: WHERE session_id = userenv('sessionid');
155:
156: END get_appointment_date;
157: --