APPS.RCV_TABLE_FUNCTIONS dependencies on PO_LOOKUP_CODES

Line 1121: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE

1117: RETURN g_muom_row;
1118: END get_muom_row_from_name;
1119:
1120: FUNCTION get_po_lookup
1121: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1122: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1123: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1124: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1125: BEGIN

Line 1122: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE

1118: END get_muom_row_from_name;
1119:
1120: FUNCTION get_po_lookup
1121: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1122: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1123: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1124: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1125: BEGIN
1126: IF NOT g_po_lookups.EXISTS(l_key) THEN

Line 1123: ) RETURN po_lookup_codes.displayed_field%TYPE IS

1119:
1120: FUNCTION get_po_lookup
1121: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1122: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1123: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1124: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1125: BEGIN
1126: IF NOT g_po_lookups.EXISTS(l_key) THEN
1127: SELECT displayed_field

Line 1129: FROM po_lookup_codes

1125: BEGIN
1126: IF NOT g_po_lookups.EXISTS(l_key) THEN
1127: SELECT displayed_field
1128: INTO g_po_lookups(l_key)
1129: FROM po_lookup_codes
1130: WHERE lookup_type = p_lookup_type
1131: AND lookup_code = p_lookup_code
1132: AND enabled_flag = 'Y';
1133: END IF;