APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PERSON_TYPES

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

4223: l_noa_family_code ghr_noa_families.noa_family_code%type;
4224:
4225: l_proc varchar2(72) := g_package || 'fetch_generic_extra_info';
4226: l_information_type ghr_pa_request_extra_info.information_type%type;
4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
4228:
4229: cursor c_bus_gp is
4230: select business_group_id
4231: from per_people_f

Line 4332: from per_person_types ppt,

4328:
4329: -- Added by Venkat -- Bug # 1236354
4330: cursor c_person_type is
4331: select ppt.system_person_type
4332: from per_person_types ppt,
4333: per_people_f ppf
4334: where ppf.person_id = p_person_id
4335: and ppt.person_type_id = ppf.person_type_id
4336: and p_effective_date