APPS.PER_QH_ACTION dependencies on PER_CONTACT_RELATIONSHIPS

Line 98: from per_contact_relationships

94: -- Start of Fix for WWBUG 1408379
95: --
96: cursor c1 is
97: select *
98: from per_contact_relationships
99: where person_id=p_person_id
100: and date_start=l_hire_date;
101: --
102: cursor c2 is

Line 104: from per_contact_relationships

100: and date_start=l_hire_date;
101: --
102: cursor c2 is
103: select *
104: from per_contact_relationships
105: where contact_person_id=p_person_id
106: and date_start=l_hire_date;
107: --
108: l_c1 c1%rowtype;

Line 227: update per_contact_relationships

223: --
224: fetch c1 into l_c1;
225: exit when c1%notfound;
226: --
227: update per_contact_relationships
228: set date_start=l_hire_date-1
229: where person_id=p_person_id
230: and date_start=l_hire_date
231: and contact_relationship_id = l_c1.contact_relationship_id;

Line 273: update per_contact_relationships

269: --
270: fetch c2 into l_c2;
271: exit when c2%notfound;
272: --
273: update per_contact_relationships
274: set date_start=l_hire_date-1
275: where contact_person_id=p_person_id
276: and date_start=l_hire_date
277: and contact_relationship_id = l_c2.contact_relationship_id;