APPS.HXC_APPROVAL_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 162: -- from pay_element_types_f pet

158: if(p_element_type_id is not null )
159: then
160: -- Perf Rep - SQL ID:3168908
161: -- select pet.element_name into l_element_name
162: -- from pay_element_types_f pet
163: -- where to_char(pet.element_type_id) = p_element_type_id;
164:
165: select pet.element_name into l_element_name
166: from pay_element_types_f pet

Line 166: from pay_element_types_f pet

162: -- from pay_element_types_f pet
163: -- where to_char(pet.element_type_id) = p_element_type_id;
164:
165: select pet.element_name into l_element_name
166: from pay_element_types_f pet
167: where pet.element_type_id = to_number(p_element_type_id);
168:
169: end if;
170: return l_element_name;