DBA Data[Home] [Help]

APPS.HR_BPL_ALERT_ADDRESS dependencies on HR_GENERAL

Line 394: ,hr_general.end_of_time)

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

Line 397: ,hr_general.start_of_time)

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;

Line 399: ,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;
402: --
403: BEGIN