APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on FND_FLEX_VALUE_SETS

Line 350: From FND_FLEX_VALUE_SETS

346: --
347: Cursor csr_value_set_id (p_value_set_name IN Varchar2)
348: Is
349: Select FLEX_VALUE_SET_ID
350: From FND_FLEX_VALUE_SETS
351: Where validation_type = 'F'
352: And
353: FLEX_VALUE_SET_NAME = p_value_set_name;
354:

Line 1912: FROM fnd_flex_value_sets

1908: --
1909: -- get Value Set Id
1910: CURSOR csr_value_set IS
1911: SELECT flex_value_set_id
1912: FROM fnd_flex_value_sets
1913: WHERE validation_type = 'F'
1914: AND flex_value_set_name = (SELECT pgt.child_value_set
1915: FROM per_gen_hier_node_types pgt
1916: WHERE pgt.hier_node_type_id = p_node_type_id);