APPS.HR_SIGNON dependencies on HR_GENERAL

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

242: AND p1.business_group_id = p_business_group_id
243: AND p1.security_group_id = p_security_group_id
244: -- AND SYSDATE BETWEEN p1.start_date -- modified for the bug 6344997
245: AND trunc(SYSDATE) BETWEEN p1.start_date
246: AND NVL(p1.end_date, hr_general.END_OF_TIME);
247: --
248: CURSOR c_get_implicit_sp
249: IS
250: SELECT MIN(security_profile_id)