APPS.PAY_AU_GENERIC_CODE_CALLER dependencies on FND_SESSIONS

Line 64: -- cursor to check fnd_sessions record exists

60: and p.legislation_code is null)
61: or (p.business_group_id = p_business_group_id)
62: or (p.legislation_code = p_legislation_code)) ;
63:
64: -- cursor to check fnd_sessions record exists
65:
66: cursor c_session is
67: select 'ok'
68: from fnd_sessions

Line 68: from fnd_sessions

64: -- cursor to check fnd_sessions record exists
65:
66: cursor c_session is
67: select 'ok'
68: from fnd_sessions
69: where session_id = userenv('sessionid') ;
70:
71: -- cursor to find process parameters
72:

Line 116: -- check that there's a record in fnd_sessions (the Oracle

112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle
117: -- FastFormula harness crashes if no fnd_sessions record present).
118:
119: open c_session ;
120: fetch c_session

Line 117: -- FastFormula harness crashes if no fnd_sessions record present).

113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle
117: -- FastFormula harness crashes if no fnd_sessions record present).
118:
119: open c_session ;
120: fetch c_session
121: into l_dummy ;