APPS.HR_PERSON dependencies on PER_PEOPLE_F

Line 346: from per_people_f ppf

342: if p_applicant_number is NOT NULL then
343: begin
344: select person_id
345: into l_person_id
346: from per_people_f ppf
347: where ppf.applicant_number = p_applicant_number
348: and ppf.business_group_id +0 = p_business_group_id
349: and rownum = 1;
350:

Line 388: from per_people_f

384: -- 3652025 >>
385: if (p_applicant_number is NULL) then
386: begin
387: select applicant_number into p_applicant_number
388: from per_people_f
389: where person_id = p_person_id
390: and applicant_number is not null
391: and rownum = 1;
392: exception

Line 483: from per_people_f ppf

479: if p_employee_number is NOT NULL then
480: begin
481: select person_id
482: into l_person_id
483: from per_people_f ppf
484: where ppf.employee_number = p_employee_number
485: and ppf.business_group_id +0 = p_business_group_id
486: and rownum = 1;
487:

Line 615: from per_people_f ppf

611: if p_npw_number is NOT NULL then
612: begin
613: select person_id
614: into l_person_id
615: from per_people_f ppf
616: where ppf.npw_number = p_npw_number
617: and ppf.business_group_id +0 = p_business_group_id
618: and rownum = 1;
619:

Line 1892: row therefore may not exist in per_people_f (for this person_id).

1888: Cascades are all performed according to the locking ladder.
1889: NOTE
1890: P_FORM_CALL is set to 'Y' if this procedure is called from a forms
1891: module. In this case, the deletes are performed post-delete and a
1892: row therefore may not exist in per_people_f (for this person_id).
1893: For this reason the existance check will be ignored.
1894: */
1895: --
1896: PROCEDURE delete_a_person (p_person_id IN number,

Line 2019: from per_people_f ppf

2015: into p_test_func
2016: from sys.dual
2017: where exists(
2018: select 'Future Person Type exists'
2019: from per_people_f ppf
2020: ,per_person_types ppt
2021: ,per_startup_person_types pst
2022: where ppf.person_type_id = ppt.person_type_id
2023: and ppf.person_id = p_person_id

Line 2124: from per_people_f ppf

2120:
2121:
2122: /*
2123: select 'Previous Person type exists'
2124: from per_people_f ppf
2125: ,per_person_types ppt
2126: ,per_startup_person_types pst
2127: where ppf.person_type_id = ppt.person_type_id
2128: and ppf.person_id = p_person_id