APPS.PAY_CA_RULES dependencies on FND_SESSIONS

Line 452: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

448: -- hr_utility.raise_error;
449: --
450: END IF;
451:
452: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
453: -- record if one doe not already exist.
454: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
455: INTO v_fnd_sess_row
456: FROM fnd_sessions

Line 456: FROM fnd_sessions

452: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
453: -- record if one doe not already exist.
454: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
455: INTO v_fnd_sess_row
456: FROM fnd_sessions
457: WHERE session_id = userenv('sessionid');
458:
459: IF v_fnd_sess_row = 'N' THEN
460: dt_fndate.set_effective_date(trunc(sysdate));