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 NULL
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.employee_number = p_person_number

Line 99: FROM per_all_people_f pp

95: SELECT 'N'
96: INTO l_status
97: FROM sys.dual
98: WHERE exists (select 'Y'
99: FROM per_all_people_f pp
100: WHERE (p_person_id IS NULL
101: OR p_person_id <> pp.person_id)
102: AND pp.business_group_id = p_business_group_id
103: AND (pp.npw_number = p_person_number

Line 119: FROM per_all_people_f pp

115: SELECT 'N'
116: INTO l_status
117: FROM sys.dual
118: WHERE exists (select NULL
119: FROM per_all_people_f pp
120: WHERE (p_person_id IS NULL
121: OR p_person_id <> pp.person_id)
122: AND pp.business_group_id = p_business_group_id
123: AND (pp.npw_number = p_person_number

Line 1188: FROM per_all_people_f pp

1184: SELECT 'Y'
1185: INTO l_status
1186: FROM sys.dual
1187: WHERE EXISTS (SELECT 'Duplicate Person Exists'
1188: FROM per_all_people_f pp
1189: WHERE /* Perform case insensitive check on last name */
1190: /* trying to use the index on last name */
1191: upper(pp.last_name) = upper(p_last_name)
1192: AND ( pp.last_name like l_ul_check

Line 1443: FROM per_all_people_f pp

1439: SELECT 'Y'
1440: INTO l_status
1441: FROM sys.dual
1442: WHERE exists(SELECT '1'
1443: FROM per_all_people_f pp
1444: WHERE (p_person_id IS NULL
1445: OR p_person_id <> pp.person_id)
1446: AND p_national_identifier = pp.national_identifier
1447: AND pp.business_group_id +0 = p_business_group_id

Line 1686: -- FROM per_all_people_f pp

1682: -- SELECT 'Y'
1683: -- INTO l_status
1684: -- FROM sys.dual
1685: -- WHERE exists (SELECT 'Y'
1686: -- FROM per_all_people_f pp
1687: -- WHERE (p_person_id IS NULL
1688: -- OR p_person_id <> pp.person_id)
1689: -- AND pp.business_group_id +0 = p_business_group_id
1690: -- AND pp.applicant_number = p_applicant_number);

Line 1739: -- FROM per_all_people_f pp

1735: -- SELECT 'Y'
1736: -- INTO l_status
1737: -- FROM sys.dual
1738: -- WHERE exists (select 'Y'
1739: -- FROM per_all_people_f pp
1740: -- WHERE (p_person_id IS NULL
1741: -- OR p_person_id <> pp.person_id)
1742: -- AND pp.business_group_id = p_business_group_id
1743: -- AND (pp.employee_number = p_employee_number

Line 1776: -- FROM per_all_people_f pp

1772: -- SELECT 'Y'
1773: -- INTO l_status
1774: -- FROM sys.dual
1775: -- WHERE exists (select 'Y'
1776: -- FROM per_all_people_f pp
1777: -- WHERE (p_person_id IS NULL
1778: -- OR p_person_id <> pp.person_id)
1779: -- AND pp.business_group_id = p_business_group_id
1780: -- AND (pp.npw_number = p_npw_number

Line 2246: from per_all_people_f ppf ,

2242: where exists
2243: (
2244: -- code change start for bug 3957689
2245: select 'Previous Person type exists'
2246: from per_all_people_f ppf ,
2247: per_person_types ppt ,
2248: per_startup_person_types pst ,
2249: per_person_type_usages_f ptu
2250: where ppf.person_id = p_person_id