APPS.HXT_RETRIEVAL_ROLLBACK dependencies on FND_SESSIONS

Line 65: DELETE FROM FND_SESSIONS

61:
62:
63: BEGIN
64:
65: DELETE FROM FND_SESSIONS
66: WHERE session_id = USERENV('SESSIONID');
67:
68:
69: INSERT INTO FND_SESSIONS

Line 69: INSERT INTO FND_SESSIONS

65: DELETE FROM FND_SESSIONS
66: WHERE session_id = USERENV('SESSIONID');
67:
68:
69: INSERT INTO FND_SESSIONS
70: ( session_id,effective_date)
71: VALUES ( USERENV('SESSIONID'),TRUNC(SYSDATE));
72:
73: END set_session_date;

Line 1840: FND_sessions sess

1836:
1837: CURSOR get_row
1838: IS SELECT ROWIDTOCHAR(tim.ROWID)
1839: FROM hxt_timecards_f tim,
1840: FND_sessions sess
1841: WHERE id = p_tim_id
1842: AND session_id = USERENV('SESSIONID')
1843: AND effective_date BETWEEN effective_start_date
1844: AND effective_end_date;

Line 2004: FND_sessions sess,

2000: FROM hxt_sum_hours_worked_f sum,
2001: hxt_det_hours_worked_f det,
2002: hxc_ret_pay_latest_details ret,
2003: hxc_ret_pay_details ret2,
2004: FND_sessions sess,
2005: pay_batch_lines pbl
2006: WHERE sum.tim_id = p_tim_id
2007: AND sess.session_id = USERENV('sessionid')
2008: AND sess.effective_date BETWEEN sum.effective_start_date

Line 2028: FND_Sessions sess

2024: pbl.object_version_number
2025: FROM hxt_det_hours_worked_f det,
2026: hxt_sum_hours_worked_f sum,
2027: pay_batch_lines pbl,
2028: FND_Sessions sess
2029: WHERE sum.tim_id = p_tim_id
2030: AND sess.session_id = USERENV('sessionid')
2031: AND sess.effective_date BETWEEN sum.effective_start_date
2032: AND sum.effective_end_date