[Home] [Help]
1741: -- statement to insert bottom level children
1742: -- If ADDITIONAL_WHERE_CLAUSE is populated use it in dynamic sql.
1743: Select ADDITIONAL_WHERE_CLAUSE
1744: into v_add_where
1745: from fnd_flex_validation_tables
1746: where pv_traversal_rarray(i_hier_ctr).aol_vs_id = FLEX_VALUE_SET_ID;
1747:
1748: if v_add_where is NULL or Instr(upper(v_add_where), 'WHERE', 1) = 0 then
1749: V_Where := ' WHERE vh.flex_value_set_id = ' || v_aol_vs_id || '