APPS.PAY_US_TAX_BALS_ADJ_API dependencies on FND_SESSIONS

Line 2866: INSERT INTO fnd_sessions(session_id, effective_date)

2862: SAVEPOINT create_tax_bal_adjustment;
2863:
2864: -- insert a row INTO fnd_session if there isn't one
2865: BEGIN
2866: INSERT INTO fnd_sessions(session_id, effective_date)
2867: SELECT USERENV('sessionid'), SYSDATE
2868: FROM DUAL
2869: WHERE NOT EXISTS (SELECT '1'
2870: FROM fnd_sessions

Line 2870: FROM fnd_sessions

2866: INSERT INTO fnd_sessions(session_id, effective_date)
2867: SELECT USERENV('sessionid'), SYSDATE
2868: FROM DUAL
2869: WHERE NOT EXISTS (SELECT '1'
2870: FROM fnd_sessions
2871: WHERE session_id = USERENV('sessionid'));
2872:
2873: END;
2874: