167: SELECT 'Y'
168: FROM per_contact_relationships
169: WHERE person_id = p_person_id
170: AND primary_contact_flag = 'Y'
171: AND NVL(date_start, Hr_General.start_of_time) <=
172: NVL(p_date_end,Hr_General.end_of_time)
173: AND NVL(date_end, Hr_General.end_of_time) >=
174: NVL(p_date_start,Hr_General.start_of_time)
175: AND ((ROWID <> CHARTOROWID(p_rowid)
168: FROM per_contact_relationships
169: WHERE person_id = p_person_id
170: AND primary_contact_flag = 'Y'
171: AND NVL(date_start, Hr_General.start_of_time) <=
172: NVL(p_date_end,Hr_General.end_of_time)
173: AND NVL(date_end, Hr_General.end_of_time) >=
174: NVL(p_date_start,Hr_General.start_of_time)
175: AND ((ROWID <> CHARTOROWID(p_rowid)
176: AND p_rowid IS NOT NULL)
169: WHERE person_id = p_person_id
170: AND primary_contact_flag = 'Y'
171: AND NVL(date_start, Hr_General.start_of_time) <=
172: NVL(p_date_end,Hr_General.end_of_time)
173: AND NVL(date_end, Hr_General.end_of_time) >=
174: NVL(p_date_start,Hr_General.start_of_time)
175: AND ((ROWID <> CHARTOROWID(p_rowid)
176: AND p_rowid IS NOT NULL)
177: OR (p_rowid IS NULL)
170: AND primary_contact_flag = 'Y'
171: AND NVL(date_start, Hr_General.start_of_time) <=
172: NVL(p_date_end,Hr_General.end_of_time)
173: AND NVL(date_end, Hr_General.end_of_time) >=
174: NVL(p_date_start,Hr_General.start_of_time)
175: AND ((ROWID <> CHARTOROWID(p_rowid)
176: AND p_rowid IS NOT NULL)
177: OR (p_rowid IS NULL)
178: );
197: p_contact_relationship_id NUMBER,
198: p_date_start DATE,
199: p_date_end DATE ) RETURN BOOLEAN IS
200: l_records VARCHAR2(1);
201: l_start_of_time DATE := Hr_General.start_of_time;
202: l_end_of_time DATE := Hr_General.end_of_time;
203: CURSOR c IS
204: SELECT 'X'
205: FROM per_contact_relationships per
198: p_date_start DATE,
199: p_date_end DATE ) RETURN BOOLEAN IS
200: l_records VARCHAR2(1);
201: l_start_of_time DATE := Hr_General.start_of_time;
202: l_end_of_time DATE := Hr_General.end_of_time;
203: CURSOR c IS
204: SELECT 'X'
205: FROM per_contact_relationships per
206: WHERE per.person_id = p_person_id
903: p_local_name => l_local_name,
904: p_duplicate_flag => l_dup_name
905: );
906: --
907: l_effective_end_date := Hr_General.end_of_time;
908: l_effective_start_date := x_session_date;
909: l_start_date := x_session_date;
910: --
911: OPEN C2;