DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 3475: FROM fnd_flex_value_hierarchies

3471: BEGIN -- Finding Parent From GL
3472: -- Finding the parent
3473: SELECT parent_flex_value
3474: INTO vl_ussgl_acct_num
3475: FROM fnd_flex_value_hierarchies
3476: WHERE (acct_num Between child_flex_value_low
3477: AND child_flex_value_high)
3478: AND flex_value_set_id = v_acc_val_set_id
3479: AND parent_flex_value <> 'T'

Line 4231: FROM fnd_flex_value_hierarchies

4227: -- Finding the parent of the Account Number in GL
4228: BEGIN /* Finding Parent From GL */
4229: SELECT parent_flex_value
4230: INTO sgl_acct_num
4231: FROM fnd_flex_value_hierarchies
4232: WHERE (acct_num Between child_flex_value_low
4233: AND child_flex_value_high)
4234: AND flex_value_set_id = v_acc_val_set_id
4235: AND parent_flex_value <> 'T'