APPS.FV_FACTS_TBAL_TRX dependencies on FND_ID_FLEX_SEGMENTS

Line 2657: from fnd_id_flex_segments

2653: Begin
2654: -- Getting the Value set Id for finding hierarchies
2655: select flex_value_set_id
2656: into vl_prg_val_set_id
2657: from fnd_id_flex_segments
2658: where application_column_name = vl_prg_seg_name
2659: and application_id = 101
2660: and id_flex_code = 'GL#'
2661: and id_flex_num = vp_coa_id ;

Line 3194: FROM fnd_id_flex_segments

3190:
3191:
3192: SELECT flex_value_set_id
3193: INTO v_acc_val_set_id
3194: FROM fnd_id_flex_segments
3195: WHERE application_column_name = v_acc_seg_name
3196: AND application_id = 101
3197: AND id_flex_code = 'GL#'
3198: AND id_flex_num = vp_coa_id;

Line 3246: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;

3242: -- ------------------------------------------------------------------
3243: Procedure PROCESS_EACH_FUND
3244: IS
3245: l_module_name VARCHAR2(200) := g_module_name || 'PROCESS_EACH_FUND';
3246: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;
3247: CURSOR C_Get_Fund_Values
3248: IS
3249: SELECT flex_value
3250: FROM fnd_flex_values_vl

Line 3271: From fnd_id_flex_segments

3267: BEGIN
3268: -- Getting the value set id for the Balancing Segment
3269: Select flex_value_set_id
3270: Into vl_bal_flex_id
3271: From fnd_id_flex_segments
3272: Where application_id = 101
3273: And application_column_name = v_bal_seg_name
3274: And id_flex_code = 'GL#'
3275: And id_flex_num = vp_coa_id;