APPS.GHR_UTILITY dependencies on DUAL

Line 428: where session_id = (select userenv('sessionid') from dual);

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
432: l_child_exists := FALSE;

Line 459: -- when they're having child individual positions attached to it

455: END LOOP;
456: END IF;
457:
458: -- Raise error when master position segments are changed
459: -- when they're having child individual positions attached to it
460: IF p_information6 IS NULL or p_information6 = hr_api.g_varchar2 THEN
461: hr_utility.set_location(' Validate_NFC ',40);
462: -- Check if the segment values have changed.
463: FOR c_old_rec in c_old_pos_segments(P_POSITION_ID,l_session_date) LOOP

Line 573: where session_id = (select userenv('sessionid') from dual);

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
577: hr_utility.set_location('Entering: HR_POSITION_BK1.CREATE_POSITION_B', 10);