APPS.GHR_PROCESS_SF52 dependencies on PER_PERSON_TYPES

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

3486: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3487: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3488: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3489: l_second_noa_code ghr_pa_requests.second_noa_code%type;
3490: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3491: l_prd varchar2(30);
3492: l_person_id ghr_pa_requests.person_id%type;
3493: l_temp_to_position_id ghr_pa_requests.to_position_id%type;
3494: l_pm varchar2(50);

Line 3533: per_person_types ppt

3529: -- Bug # 1239688 --
3530: cursor get_person_type is
3531: select ppt.system_person_type
3532: from per_people_f ppf,
3533: per_person_types ppt
3534: where ppf.person_id = p_person_id
3535: and p_effective_date
3536: between ppf.effective_start_date
3537: and ppf.effective_end_date

Line 5773: per_person_types ppt

5769:
5770: cursor get_person_type is
5771: select ppt.system_person_type
5772: from per_people_f ppf,
5773: per_person_types ppt
5774: where ppf.person_id = p_sf52_data.person_id
5775: and p_sf52_data.effective_date
5776: between ppf.effective_start_date
5777: and ppf.effective_end_date

Line 5783: l_per_type per_person_types.system_person_type%type;

5779:
5780:
5781: l_result Boolean;
5782: l_ovn ghr_pa_requests.object_version_number%type;
5783: l_per_type per_person_types.system_person_type%type;
5784: l_sf52_data ghr_pa_requests%rowtype;
5785:
5786:
5787: Begin