APPS.PY_SE_TAX_CARD dependencies on FND_SESSIONS

Line 126: from fnd_sessions

122:
123: CURSOR CSR_CHECK_FND_SESSION
124: is
125: select session_id
126: from fnd_sessions
127: where session_id = userenv('sessionid')
128: and effective_date = p_effective_date;
129:
130: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;

Line 136: --Insert row into fnd_Sessions table.

132: BEGIN
133: -- if g_debug then
134: hr_utility.set_location('Entering:'|| l_proc, 1);
135: -- end if;
136: --Insert row into fnd_Sessions table.
137: OPEN CSR_CHECK_FND_SESSION;
138: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
139: IF CSR_CHECK_FND_SESSION%notfound
140: THEN

Line 141: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);

137: OPEN CSR_CHECK_FND_SESSION;
138: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
139: IF CSR_CHECK_FND_SESSION%notfound
140: THEN
141: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
142: END IF;
143: CLOSE CSR_CHECK_FND_SESSION;
144:
145: hr_utility.set_location( l_proc, 10);