APPS.HR_PERSON dependencies on PER_ALL_PEOPLE_F

Line 9: emp_number_sv per_all_people_f.employee_number%TYPE := '0'; --NUMBER := 0;

5:
6: -- Bug 2678794: defintions changed to varchar2
7: -- to avoid ORA-06502 when implicit numeric conversions occur.
8: --
9: emp_number_sv per_all_people_f.employee_number%TYPE := '0'; --NUMBER := 0;
10: apl_number_sv per_all_people_f.applicant_number%TYPE := '0'; --NUMBER := 0;
11: npw_number_sv per_all_people_f.npw_number%TYPE := '0'; --NUMBER := 0;
12:
13: -- --------------------------------------------------------------------- +

Line 10: apl_number_sv per_all_people_f.applicant_number%TYPE := '0'; --NUMBER := 0;

6: -- Bug 2678794: defintions changed to varchar2
7: -- to avoid ORA-06502 when implicit numeric conversions occur.
8: --
9: emp_number_sv per_all_people_f.employee_number%TYPE := '0'; --NUMBER := 0;
10: apl_number_sv per_all_people_f.applicant_number%TYPE := '0'; --NUMBER := 0;
11: npw_number_sv per_all_people_f.npw_number%TYPE := '0'; --NUMBER := 0;
12:
13: -- --------------------------------------------------------------------- +
14: -- #2660279 Is_Unique_Person_number +

Line 11: npw_number_sv per_all_people_f.npw_number%TYPE := '0'; --NUMBER := 0;

7: -- to avoid ORA-06502 when implicit numeric conversions occur.
8: --
9: emp_number_sv per_all_people_f.employee_number%TYPE := '0'; --NUMBER := 0;
10: apl_number_sv per_all_people_f.applicant_number%TYPE := '0'; --NUMBER := 0;
11: npw_number_sv per_all_people_f.npw_number%TYPE := '0'; --NUMBER := 0;
12:
13: -- --------------------------------------------------------------------- +
14: -- #2660279 Is_Unique_Person_number +
15: -- --------------------------------------------------------------------- +

Line 34: FROM per_all_people_f pp

30: SELECT 'N'
31: INTO l_status
32: FROM sys.dual
33: WHERE exists (SELECT 'Y'
34: FROM per_all_people_f pp
35: WHERE (p_person_id IS NULL
36: OR p_person_id <> pp.person_id)
37: AND pp.business_group_id +0 = p_business_group_id
38: AND pp.applicant_number = p_person_number);

Line 51: FROM per_all_people_f pp

47: SELECT 'N'
48: INTO l_status
49: FROM sys.dual
50: WHERE exists (select 'Y'
51: FROM per_all_people_f pp
52: WHERE (p_person_id IS NULL
53: OR p_person_id <> pp.person_id)
54: AND pp.business_group_id = p_business_group_id
55: AND (pp.employee_number = p_person_number

Line 71: FROM per_all_people_f pp

67: SELECT 'N'
68: INTO l_status
69: FROM sys.dual
70: WHERE exists (select 'Y'
71: FROM per_all_people_f pp
72: WHERE (p_person_id IS NULL
73: OR p_person_id <> pp.person_id)
74: AND pp.business_group_id = p_business_group_id
75: AND (pp.npw_number = p_person_number

Line 1137: FROM per_all_people_f pp

1133: SELECT 'Y'
1134: INTO l_status
1135: FROM sys.dual
1136: WHERE EXISTS (SELECT 'Duplicate Person Exists'
1137: FROM per_all_people_f pp
1138: WHERE /* Perform case insensitive check on last name */
1139: /* trying to use the index on last name */
1140: upper(pp.last_name) = upper(p_last_name)
1141: AND ( pp.last_name like l_ul_check

Line 1392: FROM per_all_people_f pp

1388: SELECT 'Y'
1389: INTO l_status
1390: FROM sys.dual
1391: WHERE exists(SELECT '1'
1392: FROM per_all_people_f pp
1393: WHERE (p_person_id IS NULL
1394: OR p_person_id <> pp.person_id)
1395: AND p_national_identifier = pp.national_identifier
1396: AND pp.business_group_id +0 = p_business_group_id

Line 1635: -- FROM per_all_people_f pp

1631: -- SELECT 'Y'
1632: -- INTO l_status
1633: -- FROM sys.dual
1634: -- WHERE exists (SELECT 'Y'
1635: -- FROM per_all_people_f pp
1636: -- WHERE (p_person_id IS NULL
1637: -- OR p_person_id <> pp.person_id)
1638: -- AND pp.business_group_id +0 = p_business_group_id
1639: -- AND pp.applicant_number = p_applicant_number);

Line 1688: -- FROM per_all_people_f pp

1684: -- SELECT 'Y'
1685: -- INTO l_status
1686: -- FROM sys.dual
1687: -- WHERE exists (select 'Y'
1688: -- FROM per_all_people_f pp
1689: -- WHERE (p_person_id IS NULL
1690: -- OR p_person_id <> pp.person_id)
1691: -- AND pp.business_group_id = p_business_group_id
1692: -- AND (pp.employee_number = p_employee_number

Line 1725: -- FROM per_all_people_f pp

1721: -- SELECT 'Y'
1722: -- INTO l_status
1723: -- FROM sys.dual
1724: -- WHERE exists (select 'Y'
1725: -- FROM per_all_people_f pp
1726: -- WHERE (p_person_id IS NULL
1727: -- OR p_person_id <> pp.person_id)
1728: -- AND pp.business_group_id = p_business_group_id
1729: -- AND (pp.npw_number = p_npw_number

Line 2095: from per_all_people_f ppf ,

2091: where exists
2092: (
2093: -- code change start for bug 3957689
2094: select 'Previous Person type exists'
2095: from per_all_people_f ppf ,
2096: per_person_types ppt ,
2097: per_startup_person_types pst ,
2098: per_person_type_usages_f ptu
2099: where ppf.person_id = p_person_id