APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on FND_SESSIONS

Line 1092: from fnd_sessions

1088: --
1089: CURSOR CSR_CHECK_FND_SESSION (p_eff_date date)
1090: is
1091: select session_id
1092: from fnd_sessions
1093: where session_id = userenv('sessionid')
1094: and effective_date = p_eff_date;
1095: --
1096: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;

Line 1120: --Insert row into fnd_Sessions table.

1116: l_effective_start_date := trunc(p_effective_start_date);
1117: l_effective_end_date := trunc(p_effective_end_date);
1118: l_date_earned := trunc(p_date_earned);
1119:
1120: --Insert row into fnd_Sessions table.
1121: OPEN CSR_CHECK_FND_SESSION (l_effective_date);
1122: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
1123: IF CSR_CHECK_FND_SESSION%notfound
1124: THEN

Line 1125: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), l_effective_date);

1121: OPEN CSR_CHECK_FND_SESSION (l_effective_date);
1122: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
1123: IF CSR_CHECK_FND_SESSION%notfound
1124: THEN
1125: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), l_effective_date);
1126: END IF;
1127:
1128: CLOSE CSR_CHECK_FND_SESSION;
1129: --