APPS.PER_HU_ASSIGN_EXTRA_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 65: WHERE paaf.assignment_id=(select assignment_id from per_assignment_extra_info

61: ) IS
62: CURSOR get_assignment_type is
63: SELECT assignment_type
64: FROM per_all_assignments_f paaf, fnd_sessions fs
65: WHERE paaf.assignment_id=(select assignment_id from per_assignment_extra_info
66: where assignment_extra_info_id=p_assignment_extra_info_id)
67: AND fs.session_id = userenv('sessionid')
68: AND fs.effective_date BETWEEN paaf.effective_start_date
69: and paaf.effective_end_date;