147: FROM fv_facts_ussgl_accounts
148: WHERE ussgl_account = SUBSTR(parent_flex_value, 1, 6))
149: AND parent_flex_value IN
150: (SELECT flex_value
151: FROM fnd_flex_values
152: WHERE flex_value_set_id = g_acc_value_set_id
153: AND enabled_flag = 'Y');
154:
155: log(l_module, 'gtas_sgl_acct_number: ' || p_gtas_sgl_acct_num);