DBA Data[Home] [Help]

APPS.PER_IN_ASG_LEG_HOOK dependencies on FND_SESSIONS

Line 66: ,fnd_sessions ses

62: CURSOR c_previous_gre IS
63: SELECT scl.segment1,scl.segment2,scl.segment4
64: FROM per_all_assignments_f asg
65: ,hr_soft_coding_keyflex scl
66: ,fnd_sessions ses
67: WHERE asg.assignment_id = p_assignment_id
68: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
69: AND ses.session_id = userenv('SESSIONID')
70: AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;