APPS.GHR_UTILITY dependencies on DUAL

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

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

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

445: END LOOP;
446: END IF;
447:
448: -- Raise error when master position segments are changed
449: -- when they're having child individual positions attached to it
450: IF p_information6 IS NULL or p_information6 = hr_api.g_varchar2 THEN
451: hr_utility.set_location(' Validate_NFC ',40);
452: -- Check if the segment values have changed.
453: FOR c_old_rec in c_old_pos_segments(P_POSITION_ID,l_session_date) LOOP

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

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