290: l_element_name := Null;
291: END;
292:
293: /***********************************************
294: * Get the Meaning from Pa_Lookups
295: * table, for the lookup_type = 'REVENUE CATEGORY'
296: * and lookup code = the l_revenue_category_code.
297: ************************************************/
298: BEGIN
297: ************************************************/
298: BEGIN
299: SELECT lk.Meaning
300: INTO l_element_name
301: FROM PA_LOOKUPS lk
302: WHERE lk.Lookup_Type = 'REVENUE CATEGORY'
303: and lk.lookup_code = l_revenue_category_code;
304: EXCEPTION
305: WHEN OTHERS THEN
1624: fnd_global.user_id,
1625: sysdate,
1626: fnd_global.user_id,
1627: fnd_global.login_id
1628: FROM --pa_lookups lk,
1629: fnd_lookup_values lk,
1630: pa_rbs_element_names_b a
1631: WHERE
1632: a.resource_type_id = -2