APPS.HRI_OPL_RECRUITMENT dependencies on HRI_MB_APL_ACTIVITY_V

Line 348: FROM hri_mb_apl_activity_v aac

344: 'END_SCCSS', aac.hire_date - aac.accepted_date,
345: to_number(null))) days_accept_to_hire
346: ,AVG(aac.accepted_date - p_date_from) days_to_accept
347: ,COUNT(aac.assignment_id) vacancy_apl_count
348: FROM hri_mb_apl_activity_v aac
349: WHERE fk_vacancy_id = p_vacancy_id; -- bug 4992287 performance enh.
350:
351: BEGIN
352: