APPS.HR_PERSON dependencies on PER_ASSIGNMENTS_F

Line 375: from per_assignments_f paf

371: into p_applicant_number
372: from sys.dual
373: where (p_person_id is not null
374: and not exists (select '1'
375: from per_assignments_f paf
376: where assignment_type = 'A'
377: and paf.person_id = p_person_id
378: )
379: );

Line 511: from per_assignments_f paf

507: into p_employee_number
508: from sys.dual
509: where (p_person_id is not null
510: and not exists (select '1'
511: from per_assignments_f paf
512: where assignment_type = 'E'
513: and paf.person_id = p_person_id
514: )
515: );

Line 646: from per_assignments_f paf

642: into p_npw_number
643: from sys.dual
644: where (p_person_id is not null
645: and not exists (select '1'
646: from per_assignments_f paf
647: where assignment_type = 'C'
648: and paf.person_id = p_person_id
649: )
650: );