APPS.PA_CI_TYPES_UTIL dependencies on PA_CI_TYPES_B
Line 48: FROM pa_ci_types_b
44: IF p_ci_type_id IS NOT NULL THEN
45: IF p_check_id_flag <> 'N' THEN
46: SELECT ci_type_id
47: INTO x_ci_type_id 48: FROM pa_ci_types_b 49: WHERE ci_type_id = p_ci_type_id
50: AND l_sysdate BETWEEN TRUNC(start_date_active)
51: AND TRUNC(NVL(end_date_active, sysdate));
52: ELSE