APPS.PA_CI_TYPES_UTIL dependencies on PA_CI_TYPES_VL

Line 14: FROM pa_ci_types_vl

10: l_temp VARCHAR2(1);
11: BEGIN
12: SELECT 'X'
13: INTO l_temp
14: FROM pa_ci_types_vl
15: WHERE (name = p_name
16: OR short_name = p_short_name)
17: AND (p_ci_type_id IS NULL
18: OR ci_type_id <> p_ci_type_id);

Line 58: FROM pa_ci_types_vl

54: END IF;
55: ELSE
56: SELECT ci_type_id
57: INTO x_ci_type_id
58: FROM pa_ci_types_vl
59: WHERE name like p_name
60: AND l_sysdate BETWEEN TRUNC(start_date_active)
61: AND TRUNC(NVL(end_date_active, sysdate));
62: END IF;