APPS.PAY_US_RULES dependencies on FND_SESSIONS

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

1985: -- hr_utility.raise_error;
1986: --
1987: END IF;
1988:
1989: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
1990: -- record if one doe not already exist.
1991: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
1992: INTO v_fnd_sess_row
1993: FROM fnd_sessions

Line 1993: FROM fnd_sessions

1989: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
1990: -- record if one doe not already exist.
1991: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
1992: INTO v_fnd_sess_row
1993: FROM fnd_sessions
1994: WHERE session_id = userenv('sessionid');
1995:
1996: IF v_fnd_sess_row = 'N' THEN
1997: dt_fndate.set_effective_date(trunc(sysdate));