DBA Data[Home] [Help]

APPS.PER_REI_SHD dependencies on PER_CONTACT_RELATIONSHIPS

Line 448: -- So we need to derive PERSON_ID from PER_CONTACT_RELATIONSHIPS table to pass

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

Line 453: from per_contact_relationships

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.