DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PA_SEGMENT_VALUE_LOOKUP_SETS

Line 2557: pa_segment_value_lookup_sets.segment_value_lookup_set_name%TYPE;

2553: x_result OUT NOCOPY VARCHAR2)
2554: AS
2555:
2556: l_seg_value_lookup_set_name
2557: pa_segment_value_lookup_sets.segment_value_lookup_set_name%TYPE;
2558:
2559: l_intermediate_value
2560: pa_segment_value_lookups.segment_value_lookup%TYPE;
2561:

Line 2635: pa_segment_value_lookup_sets sets

2631:
2632: SELECT segment_value
2633: INTO l_segment_value
2634: FROM pa_segment_value_lookups valuex,
2635: pa_segment_value_lookup_sets sets
2636: WHERE sets.segment_value_lookup_set_id =
2637: valuex.segment_value_lookup_set_id
2638: AND sets.segment_value_lookup_set_name = l_seg_value_lookup_set_name
2639: AND valuex.segment_value_lookup = l_intermediate_value;