444: End If;
445: --
446: -- PER_CONTACT_EXTRA_INFO_F is a little bit different from the other datetrack tables.
447: -- The parent of this table is PER_ALL_PEOPLE_F, but does not have column "PERSON_ID".
448: -- So we need to derive PERSON_ID from PER_CONTACT_RELATIONSHIPS table to pass
449: -- it to validate_dt_mode.
450: --
451: select person_id
452: into l_person_id
449: -- it to validate_dt_mode.
450: --
451: select person_id
452: into l_person_id
453: from per_contact_relationships
454: where contact_relationship_id = g_old_rec.contact_relationship_id;
455: --
456: -- Validate the datetrack mode mode getting the validation start
457: -- and end dates for the specified datetrack operation.