APPS.PER_TMPROFILE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 21: from per_assignment_status_types

17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in
20: (select assignment_status_type_id
21: from per_assignment_status_types
22: where per_system_status = 'TERM_ASSIGN')
23: and trunc(p_effective_date)
24: between per_all_assignments_f.effective_start_date
25: and per_all_assignments_f.effective_end_date;