DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FND_ID_FLEX_SEGMENTS

Line 728: FROM fnd_id_flex_segments

724: BEGIN
725: -- Determine the Flex Value Set Id for the Acct segment
726: SELECT flex_value_set_id
727: INTO g_acc_value_set_id
728: FROM fnd_id_flex_segments
729: WHERE application_column_name = g_acct_segment_name
730: AND application_id = g_apps_id
731: AND id_flex_code = g_id_flex_code
732: AND id_flex_num = g_coa_id ;

Line 5039: FROM fnd_id_flex_segments

5035: Begin
5036: -- Getting the Value set Id for finding hierarchies
5037: SELECT flex_value_set_id
5038: INTO l_acc_val_set_id
5039: FROM fnd_id_flex_segments
5040: WHERE application_column_name = g_acct_segment_name
5041: AND id_flex_code = 'GL#'
5042: AND id_flex_num = g_coa_id ;
5043: EXCEPTION

Line 5423: FROM fnd_id_flex_segments

5419:
5420: -- Get the program value set id
5421: SELECT flex_value_set_id
5422: INTO vl_prg_value_set_id
5423: FROM fnd_id_flex_segments
5424: WHERE application_column_name = vl_prg_seg_name
5425: AND application_id = 101
5426: AND id_flex_code = 'GL#'
5427: AND id_flex_num = g_coa_id ;