APPS.PQH_WKS_BUDGET dependencies on PER_SHARED_TYPES

Line 160: from per_shared_types

156: end;
157:
158: function get_unit_type(p_unit_id in number) return varchar2 is
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

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;

Line 1619: from per_shared_types

1615: -- Get the budget flag value stored in the information1 column
1616: --
1617: Cursor c_budget_flag is
1618: Select nvl(information1,'Y')
1619: from per_shared_types
1620: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
1621: and shared_type_id = p_availability_status_id;
1622:
1623: Begin