APPS.HR_SIGNON dependencies on HR_GENERAL

Line 273: AND NVL(p1.end_date, hr_general.END_OF_TIME);

269: AND p1.business_group_id = p_business_group_id
270: AND p1.security_group_id = p_security_group_id
271: -- AND SYSDATE BETWEEN p1.start_date -- modified for the bug 6344997
272: AND trunc(SYSDATE) BETWEEN p1.start_date
273: AND NVL(p1.end_date, hr_general.END_OF_TIME);
274: --
275: CURSOR c_get_implicit_sp
276: IS
277: SELECT MIN(security_profile_id)