APPS.PQH_GSP_STAGE_TO_HR dependencies on FND_SESSIONS

Line 1187: from fnd_sessions

1183: End If;
1184: begin
1185: select effective_date
1186: into l_effective_date
1187: from fnd_sessions
1188: where session_id = userenv('sessionid');
1189: update fnd_sessions
1190: set effective_date = p_effective_date
1191: where session_id = userenv('sessionid');

Line 1189: update fnd_sessions

1185: select effective_date
1186: into l_effective_date
1187: from fnd_sessions
1188: where session_id = userenv('sessionid');
1189: update fnd_sessions
1190: set effective_date = p_effective_date
1191: where session_id = userenv('sessionid');
1192: exception
1193: when no_data_found then

Line 1194: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'), p_effective_date);

1190: set effective_date = p_effective_date
1191: where session_id = userenv('sessionid');
1192: exception
1193: when no_data_found then
1194: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'), p_effective_date);
1195: when others then
1196: raise;
1197: end;
1198: hr_utility.set_location('effective date set',1);