APPS.HREMPTER dependencies on PER_PERSON_TYPES

Line 775: per_person_types ppt

771: --
772: CURSOR future_person_types IS
773: SELECT ppt.system_person_type
774: FROM per_people_f ppf,
775: per_person_types ppt
776: WHERE ppf.person_type_id = ppt.person_type_id
777: AND ppf.person_id = p_person_id
778: AND ppf.business_group_id + 0 = ppt.business_group_id + 0
779: AND p_action_date < ppf.effective_start_date;

Line 789: per_person_types ppt ,

785:
786: CURSOR fptypes_for_cwk1 IS
787: SELECT ppt.system_person_type
788: FROM
789: per_person_types ppt ,
790: per_person_type_usages_f pptf
791: WHERE
792: pptf.person_id = p_person_id
793: AND p_action_date < pptf.effective_start_date

Line 2282: FROM per_person_types

2278: INTO l_person_type_id
2279: , l_current_applicant_flag
2280: , l_current_employee_flag
2281: , l_current_emp_or_apl_flag
2282: FROM per_person_types
2283: WHERE business_group_id = p_business_group_id --#3735333
2284: AND default_flag = 'Y'
2285: AND active_flag = 'Y'
2286: AND ((c_emp_rec.current_applicant_flag = 'Y'

Line 3382: l_sys_per_type per_person_types.system_person_type%TYPE;

3378: FPD_FLAG BOOLEAN;
3379: --
3380: -- Changes start for the Bug#13571033
3381:
3382: l_sys_per_type per_person_types.system_person_type%TYPE;
3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;
3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

Line 3500: per_person_types pt

3496:
3497: CURSOR csr_is_end_apl IS
3498: SELECT pt.system_person_type
3499: FROM per_person_type_usages_f ptu,
3500: per_person_types pt
3501: WHERE ptu.person_id = p_person_id
3502: AND pt.person_type_id = ptu.person_type_Id
3503: AND pt.system_person_type = 'EX_APL'
3504: AND ptu.effective_start_date = p_actual_termination_date+1 ;

Line 3509: per_person_types ppt

3505:
3506: CURSOR csr_emp_ptu_info IS
3507: SELECT ptu.person_type_usage_id, ptu.object_version_number
3508: FROM per_person_type_usages_f ptu,
3509: per_person_types ppt
3510: WHERE ptu.person_id = p_person_id
3511: AND ptu.person_type_id = ppt.person_type_id
3512: AND ppt.system_person_type = 'EMP'
3513: AND ptu.effective_end_date = p_actual_termination_date;