DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on QP_LOOKUPS

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

1522: ---------------------------------------------------------------------
1523: -- FUNCTION
1524: -- get_qp_lookup_meaning
1525: -- DESCRIPTION
1526: -- Get the meaning of the given lookup code in qp_lookups.
1527: ---------------------------------------------------------------------
1528: FUNCTION get_qp_lookup_meaning(
1529: p_lookup_type IN VARCHAR2,
1530: p_lookup_code IN VARCHAR2

Line 1538: FROM qp_lookups

1534: l_meaning VARCHAR2(80);
1535:
1536: CURSOR c_meaning IS
1537: SELECT meaning
1538: FROM qp_lookups
1539: WHERE lookup_type = UPPER(p_lookup_type)
1540: AND lookup_code = UPPER(p_lookup_code);
1541: BEGIN
1542: IF p_lookup_type IS NULL OR p_lookup_code IS NULL THEN