APPS.PQH_WKS_BUDGET dependencies on PER_SHARED_TYPES_VL

Line 163: l_system_type_cd per_shared_types_vl.system_type_cd%type;

159: cursor c1 is select system_type_cd
160: from per_shared_types
161: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
162: and shared_type_id = p_unit_id;
163: l_system_type_cd per_shared_types_vl.system_type_cd%type;
164: begin
165: open c1;
166: fetch c1 into l_system_type_cd;
167: close c1;

Line 176: l_unit_name per_shared_types_vl.shared_type_name%type;

172: hr_utility.raise_error;
173: end get_unit_type;
174:
175: function get_unit_desc(p_unit_id in number) return varchar2 is
176: l_unit_name per_shared_types_vl.shared_type_name%type;
177: begin
178: l_unit_name := pqh_utility.get_unit_desc(p_unit_id);
179: return l_unit_name;
180: end;

Line 187: from per_shared_types_vl

183: so that process log form could use it.
184:
185: function get_unit_desc(p_unit_id in number) return varchar2 is
186: cursor c1 is select shared_type_name
187: from per_shared_types_vl
188: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
189: and shared_type_id = p_unit_id;
190: l_shared_type_name per_shared_types_vl.shared_type_name%type;
191: begin

Line 190: l_shared_type_name per_shared_types_vl.shared_type_name%type;

186: cursor c1 is select shared_type_name
187: from per_shared_types_vl
188: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
189: and shared_type_id = p_unit_id;
190: l_shared_type_name per_shared_types_vl.shared_type_name%type;
191: begin
192: open c1;
193: fetch c1 into l_shared_type_name;
194: close c1;