APPS.PQP_HROSS_INTEGRATION dependencies on PER_PERSON_TYPES

Line 171: ,per_person_types ppt

167: ,ppf.employee_number
168: ,ppt.person_type_id
169: ,ppf.person_id
170: FROM per_all_people_f ppf
171: ,per_person_types ppt
172: WHERE ppt.person_type_id = ppf.person_type_id
173: AND ppf.business_group_id = c_bg_grp_id
174: AND ppt.business_group_id = ppf.business_group_id
175: AND ppt.active_flag = 'Y'

Line 191: ,per_person_types ppt

187: ,ppt.active_flag
188: ,ppt.system_person_type
189: ,ppt.user_person_type
190: FROM per_person_type_usages_f ptu
191: ,per_person_types ppt
192: WHERE ptu.person_id = c_person_id
193: AND ppt.business_group_id = c_business_group_id
194: AND ppt.person_type_id = ptu.person_type_id
195: AND c_effective_date BETWEEN ptu.effective_start_date

Line 212: ,per_person_types ppt

208: SELECT ptu.person_type_id
209: ,ppt.system_person_type
210: ,ppt.user_person_type
211: FROM per_person_type_usages_f ptu
212: ,per_person_types ppt
213: WHERE ptu.person_id = c_person_id
214: AND ppt.person_type_id = ptu.person_type_id
215: AND ppt.business_group_id = c_business_group_id
216: AND ptu.effective_start_date > c_effective_date

Line 286: FROM per_person_types ppt

282: -- Cursor to get the User Person Type
283: CURSOR csr_per_type(c_person_type_id Number
284: ,c_business_group_id IN Number) IS
285: SELECT ppt.user_person_type
286: FROM per_person_types ppt
287: WHERE ppt.person_type_id = c_person_type_id
288: AND ppt.business_group_id = c_business_group_id;
289:
290: -- Cursor to get the Grade Name

Line 2746: l_user_person_type per_person_types.user_person_type%TYPE;

2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
2743: l_job_name per_jobs.NAME%TYPE;
2744: l_position_name per_positions.NAME%TYPE;
2745: l_grade_name per_grades.NAME%TYPE;
2746: l_user_person_type per_person_types.user_person_type%TYPE;
2747: l_user_sequence Number := 1;
2748: l_link_value Number;
2749:
2750: BEGIN

Line 3930: l_user_person_type per_person_types.user_person_type%TYPE;

3926:
3927: l_dp_mode Varchar2(10);
3928: l_if_end_dated Varchar2(20);
3929: l_api_name hr_api_modules.module_name%TYPE;
3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;
3934: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

Line 5543: FROM per_people_f ppf, per_person_types ppt

5539: CURSOR csr_chk_ni_exists (c_ni Varchar2
5540: ,c_bgid Number
5541: ,c_eff_date Date) IS
5542: SELECT 'Y'
5543: FROM per_people_f ppf, per_person_types ppt
5544: WHERE ppf.national_identifier = c_ni
5545: AND ppf.business_group_id = c_bgid
5546: AND ppf.business_group_id = ppt.business_group_id
5547: AND ppf.person_type_id = ppt.person_type_id

Line 8057: ,per_person_types ppt

8053: SELECT ppt.system_person_type
8054: ,ppt.user_person_type
8055: ,ppt.person_type_id
8056: FROM per_people_f ppf
8057: ,per_person_types ppt
8058: WHERE ppt.person_type_id = ppf.person_type_id
8059: AND c_effective_date BETWEEN ppf.effective_start_date
8060: AND ppf.effective_end_date
8061: AND ppf.person_id = c_person_id