DBA Data[Home] [Help]

APPS.PER_MANAGE_CONTRACTS_PKG dependencies on FND_SESSIONS

Line 16: ,fnd_sessions ses

12: CURSOR cContract(p_person_id NUMBER) IS
13: SELECT 'Y'
14: FROM per_people_f per
15: ,per_contracts_f con
16: ,fnd_sessions ses
17: WHERE per.person_id = p_person_id
18: AND con.person_id = per.person_id
19: AND ses.session_id = USERENV('sessionid')
20: AND ses.effective_date BETWEEN per.effective_start_date