APPS.AP_WEB_DB_USER_PREF_PKG dependencies on AP_POL_SCHEDULE_PERIODS

Line 61: ap_pol_schedule_periods ap

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
65: AND ap.schedule_period_id = ai.period_id

Line 76: FROM ap_pol_schedule_periods ap

72: WHEN NO_DATA_FOUND THEN
73:
74: SELECT ap.schedule_period_id
75: INTO l_period_id
76: FROM ap_pol_schedule_periods ap
77: WHERE ap.start_date <= p_start_date
78: AND nvl(ap.end_date, p_end_date + 1) >= p_end_date
79: AND policy_id = p_policy_id;
80: