DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_CONTACT_RELATIONSHIPS

Line 616: ,per_contact_relationships con

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

Line 2498: ,per_contact_relationships con

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