APPS.HRI_BPL_REC_PIPLN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 195: FROM per_assignment_status_types

191: SELECT
192: per_system_status system_status
193: ,assignment_status_type_id status_id
194: ,user_status user_status
195: FROM per_assignment_status_types
196: WHERE per_system_status IN
197: ('ACTIVE_APL','INTERVIEW1','INTERVIEW2','OFFER','ACCEPTED','TERM_APL');
198:
199: l_stage_code VARCHAR2(30);