APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_VL

Line 1230: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;

1226: where ci.ci_id = p_ci_id
1227: and cit.ci_type_id = ci.ci_type_id;
1228:
1229: l_has_resolution varchar2(1) := 'Y';
1230: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;
1231: l_res_code pa_control_items.resolution_code_id%TYPE;
1232: l_res_comment pa_control_items.resolution%TYPE;
1233: BEGIN
1234: if p_ci_id is NULL then

Line 1255: l_type_class_code pa_ci_types_vl.ci_type_class_code%TYPE;

1251:
1252: FUNCTION GetCITypeClassCode(p_ci_id in Number)
1253: return Varchar2
1254: is
1255: l_type_class_code pa_ci_types_vl.ci_type_class_code%TYPE;
1256: BEGIN
1257: if p_ci_id is NULL then
1258: return NULL;
1259: end if;