APPS.HR_CAL_ENTRY_VALUE_API dependencies on PER_GEN_HIER_NODE_TYPES
Line 382: FROM per_gen_hier_node_types pgt
378: CURSOR csr_VS IS
379: SELECT flex_value_set_id,validation_type
380: FROM fnd_flex_value_sets
381: WHERE flex_value_set_name = (SELECT pgt.child_value_set 382: FROM per_gen_hier_node_types pgt 383: WHERE pgt.child_node_type = p_node_type);
384:
385: --
386: -- get VS details for stand-alone EV..