DBA Data[Home] [Help]

APPS.PER_ES_UPDATE_PERSON dependencies on FND_SESSIONS

Line 24: ,fnd_sessions ses

20: SELECT 'Y' FROM DUAL
21: WHERE EXISTS(SELECT ppt.system_person_type
22: FROM per_person_types ppt
23: ,per_person_type_usages_f ptu
24: ,fnd_sessions ses
25: WHERE ptu.person_id = p_person_id
26: AND ppt.person_type_id = ptu.person_type_id
27: AND ses.session_id=userenv('sessionid')
28: AND ses.effective_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date