APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_VL

Line 1326: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;

1322: where ci.ci_id = p_ci_id
1323: and cit.ci_type_id = ci.ci_type_id;
1324:
1325: l_has_resolution varchar2(1) := 'Y';
1326: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;
1327: l_res_code pa_control_items.resolution_code_id%TYPE;
1328: l_res_comment pa_control_items.resolution%TYPE;
1329: BEGIN
1330: if p_ci_id is NULL then

Line 1351: l_type_class_code pa_ci_types_vl.ci_type_class_code%TYPE;

1347:
1348: FUNCTION GetCITypeClassCode(p_ci_id in Number)
1349: return Varchar2
1350: is
1351: l_type_class_code pa_ci_types_vl.ci_type_class_code%TYPE;
1352: BEGIN
1353: if p_ci_id is NULL then
1354: return NULL;
1355: end if;