APPS.PA_ACC_GEN_WF_PKG dependencies on PA_SEGMENT_VALUE_LOOKUPS

Line 2560: pa_segment_value_lookups.segment_value_lookup%TYPE;

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:
2562: l_segment_value pa_segment_value_lookups.segment_value%TYPE;
2563:
2564: no_lookup_type EXCEPTION;

Line 2562: l_segment_value pa_segment_value_lookups.segment_value%TYPE;

2558:
2559: l_intermediate_value
2560: pa_segment_value_lookups.segment_value_lookup%TYPE;
2561:
2562: l_segment_value pa_segment_value_lookups.segment_value%TYPE;
2563:
2564: no_lookup_type EXCEPTION;
2565: no_lookup_code EXCEPTION;
2566: l_error_message VARCHAR2(2000);

Line 2634: FROM pa_segment_value_lookups valuex,

2630: g_error_stage := '40';
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