APPS.PQH_PEI_DDF dependencies on PER_PEOPLE_EXTRA_INFO

Line 157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE

153:
154:
155: Procedure chk_default_role
156: (
157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
158: ,p_information_type in per_people_extra_info.information_type%TYPE
159: ,p_person_id in per_people_extra_info.person_id%TYPE
160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

Line 158: ,p_information_type in per_people_extra_info.information_type%TYPE

154:
155: Procedure chk_default_role
156: (
157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
158: ,p_information_type in per_people_extra_info.information_type%TYPE
159: ,p_person_id in per_people_extra_info.person_id%TYPE
160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
162: ) is

Line 159: ,p_person_id in per_people_extra_info.person_id%TYPE

155: Procedure chk_default_role
156: (
157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
158: ,p_information_type in per_people_extra_info.information_type%TYPE
159: ,p_person_id in per_people_extra_info.person_id%TYPE
160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
162: ) is
163:

Line 160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE

156: (
157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
158: ,p_information_type in per_people_extra_info.information_type%TYPE
159: ,p_person_id in per_people_extra_info.person_id%TYPE
160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
162: ) is
163:
164: --

Line 161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE

157: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%TYPE
158: ,p_information_type in per_people_extra_info.information_type%TYPE
159: ,p_person_id in per_people_extra_info.person_id%TYPE
160: ,p_pei_information3 in per_people_extra_info.pei_information3%TYPE
161: ,p_pei_information4 in per_people_extra_info.pei_information4%TYPE
162: ) is
163:
164: --
165: l_proc varchar2(72) := g_package||'chk_default_role';

Line 171: FROM per_people_extra_info

167: l_role_name pqh_roles.role_name%TYPE;
168: --
169: CURSOR csr_duplicate_role IS
170: SELECT pei_information3
171: FROM per_people_extra_info
172: WHERE person_extra_info_id <> p_person_extra_info_id
173: AND NVL(information_type,'X') = 'PQH_ROLE_USERS'
174: AND person_id = p_person_id
175: AND pei_information3 = p_pei_information3;

Line 180: FROM per_people_extra_info

176:
177: --
178: CURSOR csr_duplicate_default_role IS
179: SELECT pei_information3
180: FROM per_people_extra_info
181: WHERE person_extra_info_id <> p_person_extra_info_id
182: AND NVL(information_type,'X') = 'PQH_ROLE_USERS'
183: AND person_id = p_person_id
184: AND NVL(pei_information4,'N') = 'Y';