APPS.BEN_WHATIF_ELIG dependencies on PER_CONTACT_RELATIONSHIPS

Line 316: rowid, per_contact_relationships.*

312: ) is
313: --
314: cursor c_ctr is
315: select
316: rowid, per_contact_relationships.*
317: from per_contact_relationships
318: where person_id = p_person_id and
319: contact_person_id = p_contact_person_id and
320: p_effective_date between nvl(DATE_START, p_effective_date)

Line 317: from per_contact_relationships

313: --
314: cursor c_ctr is
315: select
316: rowid, per_contact_relationships.*
317: from per_contact_relationships
318: where person_id = p_person_id and
319: contact_person_id = p_contact_person_id and
320: p_effective_date between nvl(DATE_START, p_effective_date)
321: and nvl(DATE_END, p_effective_date);

Line 405: /* update per_contact_relationships

401: --
402: --
403: -- Call the API - hr_contact_rel_api.update_contact_relationships.
404: --
405: /* update per_contact_relationships
406: set date_start = per_ctr_rec.date_start,
407: date_end = per_ctr_rec.date_end,
408: CONTACT_TYPE = per_ctr_rec.CONTACT_TYPE,
409: PERSONAL_FLAG = per_ctr_rec.PERSONAL_FLAG,

Line 450: /* PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(

446: ,p_cont_attribute20 => per_ctr_rec.cont_attribute20
447: ,p_object_version_number => l_object_version_number
448: );
449:
450: /* PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
451: X_Rowid => rowidtochar(per_ctr_rec.Rowid),
452: X_Contact_Relationship_Id => per_ctr_rec.Contact_Relationship_Id,
453: X_Business_Group_Id => per_ctr_rec.Business_Group_Id,
454: X_Person_Id => per_ctr_rec.Person_Id,