APPS.HR_PERSON dependencies on PER_ASSIGNMENTS_F

Line 426: from per_assignments_f paf

422: into p_applicant_number
423: from sys.dual
424: where (p_person_id is not null
425: and not exists (select '1'
426: from per_assignments_f paf
427: where assignment_type = 'A'
428: and paf.person_id = p_person_id
429: )
430: );

Line 562: from per_assignments_f paf

558: into p_employee_number
559: from sys.dual
560: where (p_person_id is not null
561: and not exists (select '1'
562: from per_assignments_f paf
563: where assignment_type = 'E'
564: and paf.person_id = p_person_id
565: )
566: );

Line 697: from per_assignments_f paf

693: into p_npw_number
694: from sys.dual
695: where (p_person_id is not null
696: and not exists (select '1'
697: from per_assignments_f paf
698: where assignment_type = 'C'
699: and paf.person_id = p_person_id
700: )
701: );