APPS.RCV_TABLE_FUNCTIONS dependencies on PO_LOOKUP_CODES

Line 1157: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE

1153: RETURN g_muom_row;
1154: END get_muom_row_from_name;
1155:
1156: FUNCTION get_po_lookup
1157: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1158: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1159: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1160: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1161: BEGIN

Line 1158: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE

1154: END get_muom_row_from_name;
1155:
1156: FUNCTION get_po_lookup
1157: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1158: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1159: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1160: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1161: BEGIN
1162: IF NOT g_po_lookups.EXISTS(l_key) THEN

Line 1159: ) RETURN po_lookup_codes.displayed_field%TYPE IS

1155:
1156: FUNCTION get_po_lookup
1157: ( p_lookup_type IN po_lookup_codes.lookup_type%TYPE
1158: , p_lookup_code IN po_lookup_codes.lookup_code%TYPE
1159: ) RETURN po_lookup_codes.displayed_field%TYPE IS
1160: l_key VARCHAR2(80) := p_lookup_type || '-' || p_lookup_code;
1161: BEGIN
1162: IF NOT g_po_lookups.EXISTS(l_key) THEN
1163: SELECT displayed_field

Line 1165: FROM po_lookup_codes

1161: BEGIN
1162: IF NOT g_po_lookups.EXISTS(l_key) THEN
1163: SELECT displayed_field
1164: INTO g_po_lookups(l_key)
1165: FROM po_lookup_codes
1166: WHERE lookup_type = p_lookup_type
1167: AND lookup_code = p_lookup_code
1168: AND enabled_flag = 'Y';
1169: END IF;