APPS.AP_WEB_DB_USER_PREF_PKG dependencies on AP_WEB_EMPLOYEE_INFO_ALL

Line 60: FROM ap_web_employee_info_all ai,

56: BEGIN
57:
58: SELECT ai.numeric_value, ai.period_id
59: INTO p_cumulative_mileage, p_period_id
60: FROM ap_web_employee_info_all ai,
61: ap_pol_schedule_periods ap
62: WHERE ap.policy_id = p_policy_id
63: AND ap.start_date <= p_start_date
64: AND nvl(ap.end_date, p_end_date + 1) >= p_end_date