APPS.PAY_CA_RULES dependencies on FND_SESSIONS

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

1135: -- hr_utility.raise_error;
1136: --
1137: END IF;
1138:
1139: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
1140: -- record if one doe not already exist.
1141: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
1142: INTO v_fnd_sess_row
1143: FROM fnd_sessions

Line 1143: FROM fnd_sessions

1139: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
1140: -- record if one doe not already exist.
1141: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
1142: INTO v_fnd_sess_row
1143: FROM fnd_sessions
1144: WHERE session_id = userenv('sessionid');
1145:
1146: IF v_fnd_sess_row = 'N' THEN
1147: dt_fndate.set_effective_date(trunc(sysdate));