DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 3426: FROM fnd_flex_value_hierarchies

3422: BEGIN -- Finding Parent From GL
3423: -- Finding the parent
3424: SELECT parent_flex_value
3425: INTO vl_ussgl_acct_num
3426: FROM fnd_flex_value_hierarchies
3427: WHERE (acct_num Between child_flex_value_low
3428: AND child_flex_value_high)
3429: AND flex_value_set_id = v_acc_val_set_id
3430: AND parent_flex_value <> 'T'

Line 4159: FROM fnd_flex_value_hierarchies

4155: -- Finding the parent of the Account Number in GL
4156: BEGIN /* Finding Parent From GL */
4157: SELECT parent_flex_value
4158: INTO sgl_acct_num
4159: FROM fnd_flex_value_hierarchies
4160: WHERE (acct_num Between child_flex_value_low
4161: AND child_flex_value_high)
4162: AND flex_value_set_id = v_acc_val_set_id
4163: AND parent_flex_value <> 'T'