APPS.PAY_US_RULES dependencies on FND_SESSIONS

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

2043: -- hr_utility.raise_error;
2044: --
2045: END IF;
2046:
2047: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2048: -- record if one doe not already exist.
2049: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2050: INTO v_fnd_sess_row
2051: FROM fnd_sessions

Line 2051: FROM fnd_sessions

2047: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
2048: -- record if one doe not already exist.
2049: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
2050: INTO v_fnd_sess_row
2051: FROM fnd_sessions
2052: WHERE session_id = userenv('sessionid');
2053:
2054: IF v_fnd_sess_row = 'N' THEN
2055: dt_fndate.set_effective_date(trunc(sysdate));