APPS.GHR_PROCESS_SF52 dependencies on PER_PERSON_TYPES

Line 3618: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;

3614: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3615: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3616: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3617: l_second_noa_code ghr_pa_requests.second_noa_code%type;
3618: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3619: l_prd varchar2(30);
3620: l_prd1 varchar2(30);
3621: l_person_id ghr_pa_requests.person_id%type;
3622: l_temp_to_position_id ghr_pa_requests.to_position_id%type;

Line 3663: per_person_types ppt

3659: -- Bug # 1239688 --
3660: cursor get_person_type is
3661: select ppt.system_person_type
3662: from per_people_f ppf,
3663: per_person_types ppt
3664: where ppf.person_id = p_person_id
3665: and p_effective_date
3666: between ppf.effective_start_date
3667: and ppf.effective_end_date

Line 6051: per_person_types ppt

6047:
6048: cursor get_person_type is
6049: select ppt.system_person_type
6050: from per_people_f ppf,
6051: per_person_types ppt
6052: where ppf.person_id = p_sf52_data.person_id
6053: and p_sf52_data.effective_date
6054: between ppf.effective_start_date
6055: and ppf.effective_end_date

Line 6061: l_per_type per_person_types.system_person_type%type;

6057:
6058:
6059: l_result Boolean;
6060: l_ovn ghr_pa_requests.object_version_number%type;
6061: l_per_type per_person_types.system_person_type%type;
6062: l_sf52_data ghr_pa_requests%rowtype;
6063:
6064:
6065: Begin