APPS.PA_TRX_IMPORT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 6803: FROM per_assignment_status_types s

6799: END IF;
6800:
6801: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
6802: INTO p_person_type
6803: FROM per_assignment_status_types s
6804: ,per_all_assignments_f a
6805: WHERE a.job_id IS NOT NULL
6806: AND a.primary_flag = 'Y'
6807: AND p_date BETWEEN trunc(a.effective_start_date) AND trunc(a.effective_end_date)