APPS.FV_YE_CLOSE dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 1664: FROM Fnd_Flex_Value_Hierarchies

1660: vl_bal_cnt NUMBER;
1661:
1662: CURSOR get_hierarchies_cur IS
1663: SELECT child_flex_value_low, child_flex_value_high
1664: FROM Fnd_Flex_Value_Hierarchies
1665: WHERE parent_flex_value = vg_from_acct
1666: AND flex_value_set_id = vg_acct_val_set_id;
1667:
1668: CURSOR get_child_values_cur IS

Line 2559: vl_parent Fnd_Flex_Value_Hierarchies.parent_flex_value%TYPE;

2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2556: vl_found_flag VARCHAR2(1) ;
2557: vl_cnt NUMBER;
2558: vl_process_type VARCHAR2(10);
2559: vl_parent Fnd_Flex_Value_Hierarchies.parent_flex_value%TYPE;
2560:
2561: l_module_name VARCHAR2(200) ;
2562:
2563: BEGIN