DBA Data[Home] [Help]

APPS.JTF_PF_SOA_MIGRATE_PKG dependencies on FND_LOGIN_RESP_FORMS

Line 137: FROM fnd_login_resp_forms f, icx_sessions i, fnd_login_responsibilities r

133: i.session_id, i.user_id, f.form_appl_id, r.responsibility_id, NVL(i.language_code, -1),NVL(i.proxy_user_id, -1),
134: (trunc( (f.start_time - to_date('1970/01/01', 'YYYY/MM/DD')) * 86400 * 1000) - timezone_offset) startt,
135: 'FORM', to_char(f.form_id), 200, 0, (f.end_time - f.start_time) * 86400 * 1000 thinkt, -1, 1,
136: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.conc_login_id
137: FROM fnd_login_resp_forms f, icx_sessions i, fnd_login_responsibilities r
138: WHERE f.login_id = i.login_id
139: AND r.login_resp_id = f.login_resp_id
140: AND (maxtimestamp IS NULL
141: OR f.start_time > maxtimestamp