452:
453: l_child := l_child || flex_rec.application_column_name ||
454: ' between '|| '''' ||
455: child_rec.child_flex_value_low || ''' and '''
456: || child_rec.child_flex_value_high || '''' || fnd_global.local_chr(10);
457: l_no_of_child := l_no_of_child + 1;
458: End loop;
459: l_child := l_child || ' )' ;
460: l_and := NULL;
457: l_no_of_child := l_no_of_child + 1;
458: End loop;
459: l_child := l_child || ' )' ;
460: l_and := NULL;
461: v_statement := v_statement || l_and || L_CHILD || fnd_global.local_chr(10);
462: CLOSE CHILD_VALUE;
463: ELSE /* 2 */
464: if (l_no_of_seg > 0) then
465: l_and := ' AND ';
464: if (l_no_of_seg > 0) then
465: l_and := ' AND ';
466: End if;
467: v_statement := v_statement || l_and ||
468: flex_rec.application_column_name || ' = ''' || v_seg(l_segno) || ''' ' || fnd_global.local_chr(10);
469: End if; /* cnt > 0 */
470:
471: l_no_of_seg := l_no_of_seg + 1;
472: End if;