APPS.FV_YE_CLOSE dependencies on FND_FLEX_VALUES_VL

Line 716: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;

712: WHERE set_of_books_id = vg_sob_id
713: ORDER BY to_account;
714:
715: vl_parent_flag VARCHAR2(1) ;
716: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;
717:
718: CURSOR get_parentflag_cur IS
719: SELECT summary_flag
720: FROM Fnd_Flex_Values_Vl

Line 720: FROM Fnd_Flex_Values_Vl

716: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;
717:
718: CURSOR get_parentflag_cur IS
719: SELECT summary_flag
720: FROM Fnd_Flex_Values_Vl
721: WHERE flex_value_set_id = vg_acct_val_set_id
722: AND flex_value = vl_acct;
723:
724: l_module_name VARCHAR2(200) ;

Line 1605: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;

1601: -- calls the procedure Determine_DrCr.
1602: -- ------------------------------------------------------------------
1603: PROCEDURE Determine_Child_Accounts IS
1604: vl_parent_cnt NUMBER;
1605: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;
1606: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;
1607:
1608: TYPE t_getbal_cnt IS REF CURSOR;
1609: vc_getbal_cnt t_getbal_cnt;

Line 1606: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;

1602: -- ------------------------------------------------------------------
1603: PROCEDURE Determine_Child_Accounts IS
1604: vl_parent_cnt NUMBER;
1605: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;
1606: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;
1607:
1608: TYPE t_getbal_cnt IS REF CURSOR;
1609: vc_getbal_cnt t_getbal_cnt;
1610: vl_select VARCHAR2(2000);

Line 1621: FROM Fnd_Flex_Values_Vl

1617: AND flex_value_set_id = vg_acct_val_set_id;
1618:
1619: CURSOR get_child_values_cur IS
1620: SELECT flex_value
1621: FROM Fnd_Flex_Values_Vl
1622: WHERE flex_value_set_id = vg_acct_val_set_id
1623: AND flex_value BETWEEN vl_child_low AND vl_child_high
1624: ORDER BY flex_value;
1625:

Line 1641: FROM Fnd_Flex_Values_Vl

1637: BEGIN
1638: -- Check to see if the from account is a parent
1639: SELECT COUNT(*)
1640: INTO vl_parent_cnt
1641: FROM Fnd_Flex_Values_Vl
1642: WHERE flex_value_set_id = vg_acct_val_set_id
1643: AND summary_flag = 'Y'
1644: AND flex_value = vg_from_acct;
1645: