[Home] [Help]
5052: -- Finding the parent of the Account Number in GL
5053: BEGIN
5054: SELECT parent_flex_value
5055: Into sgl_acct_num
5056: From fnd_flex_value_hierarchies
5057: WHERE (acct_num BETWEEN child_flex_value_low
5058: AND child_flex_value_high)
5059: AND parent_flex_value <> 'T'
5060: AND flex_value_set_id = l_acc_val_set_id