APPS.GHR_UTILITY dependencies on FND_SESSIONS

Line 414: l_session_date fnd_sessions.effective_date%type;

410: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
411: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
412: l_ovn per_position_extra_info.object_version_number%type;
413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;
415: cursor c_get_session_date is
416: select trunc(effective_date) session_date
417: from fnd_sessions
418: where session_id = (select userenv('sessionid') from dual);

Line 417: from fnd_sessions

413: l_information_type per_position_extra_info.information_type%type;
414: l_session_date fnd_sessions.effective_date%type;
415: cursor c_get_session_date is
416: select trunc(effective_date) session_date
417: from fnd_sessions
418: where session_id = (select userenv('sessionid') from dual);
419:
420: BEGIN
421: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

Line 559: l_session_date fnd_sessions.effective_date%type;

555: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
556: l_pos_cre_ovn per_position_extra_info.object_version_number%type;
557: l_ovn per_position_extra_info.object_version_number%type;
558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;
560: cursor c_get_session_date is
561: select trunc(effective_date) session_date
562: from fnd_sessions
563: where session_id = (select userenv('sessionid') from dual);

Line 562: from fnd_sessions

558: l_information_type per_position_extra_info.information_type%type;
559: l_session_date fnd_sessions.effective_date%type;
560: cursor c_get_session_date is
561: select trunc(effective_date) session_date
562: from fnd_sessions
563: where session_id = (select userenv('sessionid') from dual);
564:
565: BEGIN
566: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN