DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_CONTACT_RELATIONSHIPS

Line 615: ,per_contact_relationships con

611: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1))father
612: ,pea.title title
613: FROM per_all_people_f pep
614: ,per_all_people_f pea
615: ,per_contact_relationships con
616: WHERE pep.person_id = p_person_id
617: AND pea.person_id =con.contact_person_id
618: AND pep.business_group_id = g_bg_id
619: AND pea.business_group_id = g_bg_id

Line 2432: ,per_contact_relationships con

2428: ,INSTR(hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title),' ',1)+1)) father
2429: ,pea.title title
2430: FROM per_all_people_f pep
2431: ,per_all_people_f pea
2432: ,per_contact_relationships con
2433: WHERE pep.person_id = p_person_id
2434: AND pea.person_id =con.contact_person_id
2435: AND pep.business_group_id = g_bg_id
2436: AND pea.business_group_id = g_bg_id