DBA Data[Home] [Help]

APPS.PER_KW_XDO_REPORT dependencies on PER_DISABILITIES_V

Line 432: FROM per_disabilities_v

428: l_consultation_date := NULL;
429: BEGIN
430: SELECT consultation_date
431: INTO l_consultation_date
432: FROM per_disabilities_v
433: WHERE disability_id = rec_get_dis_emp.disability_id
434: AND l_date BETWEEN effective_start_date and effective_end_date;
435: EXCEPTION
436: WHEN OTHERS THEN