390: AND psn.effective_end_date
391: AND TRUNC(SYSDATE)
392: BETWEEN con.date_start
393: AND NVL(con.date_end
394: ,hr_general.end_of_time)
395: AND TRUNC(SYSDATE)
396: BETWEEN NVL(pho.date_from
397: ,hr_general.start_of_time)
398: AND NVL(pho.date_to
393: AND NVL(con.date_end
394: ,hr_general.end_of_time)
395: AND TRUNC(SYSDATE)
396: BETWEEN NVL(pho.date_from
397: ,hr_general.start_of_time)
398: AND NVL(pho.date_to
399: ,hr_general.end_of_time);
400: --
401: v_full_name VARCHAR2(2000) := NULL;
395: AND TRUNC(SYSDATE)
396: BETWEEN NVL(pho.date_from
397: ,hr_general.start_of_time)
398: AND NVL(pho.date_to
399: ,hr_general.end_of_time);
400: --
401: v_full_name VARCHAR2(2000) := NULL;
402: --
403: BEGIN