DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on QP_LOOKUPS

Line 1602: -- Get the meaning of the given lookup code in qp_lookups.

1598: ---------------------------------------------------------------------
1599: -- FUNCTION
1600: -- get_qp_lookup_meaning
1601: -- DESCRIPTION
1602: -- Get the meaning of the given lookup code in qp_lookups.
1603: ---------------------------------------------------------------------
1604: FUNCTION get_qp_lookup_meaning(
1605: p_lookup_type IN VARCHAR2,
1606: p_lookup_code IN VARCHAR2

Line 1614: FROM qp_lookups

1610: l_meaning VARCHAR2(80);
1611:
1612: CURSOR c_meaning IS
1613: SELECT meaning
1614: FROM qp_lookups
1615: WHERE lookup_type = UPPER(p_lookup_type)
1616: AND lookup_code = UPPER(p_lookup_code);
1617: BEGIN
1618: IF p_lookup_type IS NULL OR p_lookup_code IS NULL THEN