DBA Data[Home] [Help]

APPS.BEN_PER_ASG_EIT_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 127: from per_contact_relationships

123: --
124: --
125: cursor get_contacts(p_person_id in number) is
126: select person_id
127: from per_contact_relationships
128: where contact_person_id = p_person_id
129: and business_group_id = l_business_group_id
130: and l_session_date between nvl(date_start,l_session_date)
131: and nvl(date_end,l_session_date)

Line 506: from per_contact_relationships

502: --
503: --
504: cursor get_contacts(p_person_id in number) is
505: select person_id
506: from per_contact_relationships
507: where contact_person_id = p_person_id
508: and business_group_id = l_business_group_id
509: and l_session_date between nvl(date_start,l_session_date)
510: and nvl(date_end,l_session_date)