DBA Data[Home] [Help]

APPS.GHR_MTO_INT dependencies on PER_CONTACT_RELATIONSHIPS

Line 4099: from per_contact_relationships cr, per_all_people_f p

4095: l_contact_name varchar2(240);
4096: l_contact_person_id per_people_f.person_id%type;
4097: cursor cur_contact_info(p_person_id number) is
4098: select cr.contact_type, p.full_name, cr.contact_person_id
4099: from per_contact_relationships cr, per_all_people_f p
4100: where cr.person_id = p_person_id
4101: and cr.primary_contact_flag = 'Y'
4102: and cr.contact_person_id = p.person_id
4103: and trunc(l_effdate) between p.effective_start_date