DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_CONTACT_RELATIONSHIPS

Line 488: procedure set_object(p_rec in out NOCOPY per_contact_relationships%rowtype) is

484: -- hr_utility.set_location('Leaving '||l_proc,10);
485: --
486: end set_object;
487: --
488: procedure set_object(p_rec in out NOCOPY per_contact_relationships%rowtype) is
489: --
490: l_proc varchar2(80) := g_package||'set_object ctr';
491: l_index pls_integer;
492: --

Line 1307: from per_contact_relationships con,

1303: -- the participant and does not ignore end-dated relationships.
1304: --
1305: cursor c1 is
1306: select con.*
1307: from per_contact_relationships con,
1308: per_all_people_f ppf
1309: where con.person_id = p_person_id
1310: and con.business_group_id = p_business_group_id
1311: and nvl(con.date_start,hr_api.g_sot) <= p_effective_date