612: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1))father
613: ,pea.title title
614: FROM per_all_people_f pep
615: ,per_all_people_f pea
616: ,per_contact_relationships con
617: WHERE pep.person_id = p_person_id
618: AND pea.person_id =con.contact_person_id
619: AND pep.business_group_id = g_bg_id
620: AND pea.business_group_id = g_bg_id
2494: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2495: ,pea.title title
2496: FROM per_all_people_f pep
2497: ,per_all_people_f pea
2498: ,per_contact_relationships con
2499: WHERE pep.person_id = p_person_id
2500: AND pea.person_id =con.contact_person_id
2501: AND pep.business_group_id = g_bg_id
2502: AND pea.business_group_id = g_bg_id