APPS.GHR_UTILITY dependencies on FND_SESSIONS

Line 424: l_session_date fnd_sessions.effective_date%type;

420: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
421: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
422: l_ovn per_position_extra_info.object_version_number%type;
423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;
425: cursor c_get_session_date is
426: select trunc(effective_date) session_date
427: from fnd_sessions
428: where session_id = (select userenv('sessionid') from dual);

Line 427: from fnd_sessions

423: l_information_type per_position_extra_info.information_type%type;
424: l_session_date fnd_sessions.effective_date%type;
425: cursor c_get_session_date is
426: select trunc(effective_date) session_date
427: from fnd_sessions
428: where session_id = (select userenv('sessionid') from dual);
429:
430: BEGIN
431: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

Line 569: l_session_date fnd_sessions.effective_date%type;

565: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
566: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
567: l_ovn per_position_extra_info.object_version_number%type;
568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;
570: cursor c_get_session_date is
571: select trunc(effective_date) session_date
572: from fnd_sessions
573: where session_id = (select userenv('sessionid') from dual);

Line 572: from fnd_sessions

568: l_information_type per_position_extra_info.information_type%type;
569: l_session_date fnd_sessions.effective_date%type;
570: cursor c_get_session_date is
571: select trunc(effective_date) session_date
572: from fnd_sessions
573: where session_id = (select userenv('sessionid') from dual);
574:
575: BEGIN
576: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN