DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PA_LOOKUPS

Line 294: * Get the Meaning from Pa_Lookups

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

Line 301: FROM PA_LOOKUPS lk

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

Line 1628: FROM --pa_lookups lk,

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