DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FND_ID_FLEX_SEGMENTS

Line 696: FROM fnd_id_flex_segments

692: BEGIN
693: -- Determine the Flex Value Set Id for the Acct segment
694: SELECT flex_value_set_id
695: INTO g_acc_value_set_id
696: FROM fnd_id_flex_segments
697: WHERE application_column_name = g_acct_segment_name
698: AND application_id = g_apps_id
699: AND id_flex_code = g_id_flex_code
700: AND id_flex_num = g_coa_id ;

Line 4762: FROM fnd_id_flex_segments

4758: Begin
4759: -- Getting the Value set Id for finding hierarchies
4760: SELECT flex_value_set_id
4761: INTO l_acc_val_set_id
4762: FROM fnd_id_flex_segments
4763: WHERE application_column_name = g_acct_segment_name
4764: AND id_flex_code = 'GL#'
4765: AND id_flex_num = g_coa_id ;
4766: EXCEPTION

Line 5144: FROM fnd_id_flex_segments

5140:
5141: -- Get the program value set id
5142: SELECT flex_value_set_id
5143: INTO vl_prg_value_set_id
5144: FROM fnd_id_flex_segments
5145: WHERE application_column_name = vl_prg_seg_name
5146: AND application_id = 101
5147: AND id_flex_code = 'GL#'
5148: AND id_flex_num = g_coa_id ;