APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on HR_GENERAL

Line 172: AND NVL(date_start, Hr_General.start_of_time) <=

168: SELECT 'Y'
169: FROM per_contact_relationships
170: WHERE person_id = p_person_id
171: AND primary_contact_flag = 'Y'
172: AND NVL(date_start, Hr_General.start_of_time) <=
173: NVL(p_date_end,Hr_General.end_of_time)
174: AND NVL(date_end, Hr_General.end_of_time) >=
175: NVL(p_date_start,Hr_General.start_of_time)
176: AND ((ROWID <> CHARTOROWID(p_rowid)

Line 173: NVL(p_date_end,Hr_General.end_of_time)

169: FROM per_contact_relationships
170: WHERE person_id = p_person_id
171: AND primary_contact_flag = 'Y'
172: AND NVL(date_start, Hr_General.start_of_time) <=
173: NVL(p_date_end,Hr_General.end_of_time)
174: AND NVL(date_end, Hr_General.end_of_time) >=
175: NVL(p_date_start,Hr_General.start_of_time)
176: AND ((ROWID <> CHARTOROWID(p_rowid)
177: AND p_rowid IS NOT NULL)

Line 174: AND NVL(date_end, Hr_General.end_of_time) >=

170: WHERE person_id = p_person_id
171: AND primary_contact_flag = 'Y'
172: AND NVL(date_start, Hr_General.start_of_time) <=
173: NVL(p_date_end,Hr_General.end_of_time)
174: AND NVL(date_end, Hr_General.end_of_time) >=
175: NVL(p_date_start,Hr_General.start_of_time)
176: AND ((ROWID <> CHARTOROWID(p_rowid)
177: AND p_rowid IS NOT NULL)
178: OR (p_rowid IS NULL)

Line 175: NVL(p_date_start,Hr_General.start_of_time)

171: AND primary_contact_flag = 'Y'
172: AND NVL(date_start, Hr_General.start_of_time) <=
173: NVL(p_date_end,Hr_General.end_of_time)
174: AND NVL(date_end, Hr_General.end_of_time) >=
175: NVL(p_date_start,Hr_General.start_of_time)
176: AND ((ROWID <> CHARTOROWID(p_rowid)
177: AND p_rowid IS NOT NULL)
178: OR (p_rowid IS NULL)
179: );

Line 202: l_start_of_time DATE := Hr_General.start_of_time;

198: p_contact_relationship_id NUMBER,
199: p_date_start DATE,
200: p_date_end DATE ) RETURN BOOLEAN IS
201: l_records VARCHAR2(1);
202: l_start_of_time DATE := Hr_General.start_of_time;
203: l_end_of_time DATE := Hr_General.end_of_time;
204: CURSOR c IS
205: SELECT 'X'
206: FROM per_contact_relationships per

Line 203: l_end_of_time DATE := Hr_General.end_of_time;

199: p_date_start DATE,
200: p_date_end DATE ) RETURN BOOLEAN IS
201: l_records VARCHAR2(1);
202: l_start_of_time DATE := Hr_General.start_of_time;
203: l_end_of_time DATE := Hr_General.end_of_time;
204: CURSOR c IS
205: SELECT 'X'
206: FROM per_contact_relationships per
207: WHERE per.person_id = p_person_id

Line 908: l_effective_end_date := Hr_General.end_of_time;

904: p_local_name => l_local_name,
905: p_duplicate_flag => l_dup_name
906: );
907: --
908: l_effective_end_date := Hr_General.end_of_time;
909: l_effective_start_date := x_session_date;
910: l_start_date := x_session_date;
911: --
912: OPEN C2;

Line 1894: if hr_general.chk_product_installed(805) = 'TRUE' then

1890: BEGIN
1891: --
1892:
1893: -- fix for bug8395666
1894: if hr_general.chk_product_installed(805) = 'TRUE' then
1895: ben_ELIG_DPNT_api.chk_enrt_for_dpnt(
1896: p_dpnt_person_id => X_Contact_Person_Id
1897: ,p_dpnt_rltp_id => X_Contact_Relationship_Id
1898: ,p_rltp_type => X_Contact_Type