APPS.PQH_UTILITY dependencies on PER_SHARED_TYPES_VL

Line 1158: from per_shared_types_vl

1154:
1155:
1156: function get_unit_desc(p_unit_id in number) return varchar2 is
1157: cursor c1 is select shared_type_name
1158: from per_shared_types_vl
1159: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
1160: and shared_type_id = p_unit_id;
1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;
1162: begin

Line 1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;

1157: cursor c1 is select shared_type_name
1158: from per_shared_types_vl
1159: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
1160: and shared_type_id = p_unit_id;
1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;
1162: begin
1163: open c1;
1164: fetch c1 into l_shared_type_name;
1165: close c1;