DBA Data[Home] [Help]

APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 1745: from fnd_flex_validation_tables

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 || '