DBA Data[Home] [Help]

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