APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PERSON_TYPES

Line 3470: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

3466: l_noa_family_code ghr_noa_families.noa_family_code%type;
3467:
3468: l_proc varchar2(72) := g_package || 'fetch_gneric_extra_info';
3469: l_information_type ghr_pa_request_extra_info.information_type%type;
3470: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3471:
3472: cursor c_bus_gp is
3473: select business_group_id
3474: from per_people_f

Line 3575: from per_person_types ppt,

3571:
3572: -- Added by Venkat -- Bug # 1236354
3573: cursor c_person_type is
3574: select ppt.system_person_type
3575: from per_person_types ppt,
3576: per_people_f ppf
3577: where ppf.person_id = p_person_id
3578: and ppt.person_type_id = ppf.person_type_id
3579: and p_effective_date