APPS.PER_QH_ACTION dependencies on PER_CONTACT_RELATIONSHIPS

Line 106: from per_contact_relationships

102: -- Start of Fix for WWBUG 1408379
103: --
104: cursor c1 is
105: select *
106: from per_contact_relationships
107: where person_id=p_person_id
108: and date_start=l_hire_date;
109: --
110: cursor c2 is

Line 112: from per_contact_relationships

108: and date_start=l_hire_date;
109: --
110: cursor c2 is
111: select *
112: from per_contact_relationships
113: where contact_person_id=p_person_id
114: and date_start=l_hire_date;
115: --
116: l_c1 c1%rowtype;

Line 252: update per_contact_relationships

248: --
249: fetch c1 into l_c1;
250: exit when c1%notfound;
251: --
252: update per_contact_relationships
253: set date_start=l_hire_date-1
254: where person_id=p_person_id
255: and date_start=l_hire_date
256: and contact_relationship_id = l_c1.contact_relationship_id;

Line 298: update per_contact_relationships

294: --
295: fetch c2 into l_c2;
296: exit when c2%notfound;
297: --
298: update per_contact_relationships
299: set date_start=l_hire_date-1
300: where contact_person_id=p_person_id
301: and date_start=l_hire_date
302: and contact_relationship_id = l_c2.contact_relationship_id;