DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on QP_LOOKUPS

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

1573: ---------------------------------------------------------------------
1574: -- FUNCTION
1575: -- get_qp_lookup_meaning
1576: -- DESCRIPTION
1577: -- Get the meaning of the given lookup code in qp_lookups.
1578: ---------------------------------------------------------------------
1579: FUNCTION get_qp_lookup_meaning(
1580: p_lookup_type IN VARCHAR2,
1581: p_lookup_code IN VARCHAR2

Line 1589: FROM qp_lookups

1585: l_meaning VARCHAR2(80);
1586:
1587: CURSOR c_meaning IS
1588: SELECT meaning
1589: FROM qp_lookups
1590: WHERE lookup_type = UPPER(p_lookup_type)
1591: AND lookup_code = UPPER(p_lookup_code);
1592: BEGIN
1593: IF p_lookup_type IS NULL OR p_lookup_code IS NULL THEN