2454: x_result OUT NOCOPY VARCHAR2)
2455: AS
2456:
2457: l_seg_value_lookup_set_name
2458: pa_segment_value_lookup_sets.segment_value_lookup_set_name%TYPE;
2459:
2460: l_intermediate_value
2461: pa_segment_value_lookups.segment_value_lookup%TYPE;
2462:
2532:
2533: SELECT segment_value
2534: INTO l_segment_value
2535: FROM pa_segment_value_lookups valuex,
2536: pa_segment_value_lookup_sets sets
2537: WHERE sets.segment_value_lookup_set_id =
2538: valuex.segment_value_lookup_set_id
2539: AND sets.segment_value_lookup_set_name = l_seg_value_lookup_set_name
2540: AND valuex.segment_value_lookup = l_intermediate_value;