APPS.FV_FACTS_TBAL_TRX dependencies on FND_ID_FLEX_SEGMENTS

Line 2868: from fnd_id_flex_segments

2864: Begin
2865: -- Getting the Value set Id for finding hierarchies
2866: select flex_value_set_id
2867: into vl_prg_val_set_id
2868: from fnd_id_flex_segments
2869: where application_column_name = vl_prg_seg_name
2870: and application_id = 101
2871: and id_flex_code = 'GL#'
2872: and id_flex_num = vp_coa_id ;

Line 3444: FROM FND_ID_FLEX_SEGMENTS_VL

3440: BEGIN
3441: -- Added for Bug 7324248. Get the Reimbursable Agreement segment
3442: SELECT application_column_name
3443: INTO g_reimb_agree_seg_name
3444: FROM FND_ID_FLEX_SEGMENTS_VL
3445: WHERE application_id = 101
3446: AND id_flex_code = 'GL#'
3447: AND id_flex_num = vp_coa_id
3448: AND enabled_flag = 'Y'

Line 3492: FROM fnd_id_flex_segments

3488:
3489:
3490: SELECT flex_value_set_id
3491: INTO v_acc_val_set_id
3492: FROM fnd_id_flex_segments
3493: WHERE application_column_name = v_acc_seg_name
3494: AND application_id = 101
3495: AND id_flex_code = 'GL#'
3496: AND id_flex_num = vp_coa_id;

Line 3546: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;

3542: -- ------------------------------------------------------------------
3543: Procedure PROCESS_EACH_FUND
3544: IS
3545: l_module_name VARCHAR2(200) := g_module_name || 'PROCESS_EACH_FUND';
3546: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;
3547: CURSOR C_Get_Fund_Values
3548: IS
3549: SELECT flex_value
3550: FROM fnd_flex_values_vl

Line 3573: From fnd_id_flex_segments

3569: BEGIN
3570: -- Getting the value set id for the Balancing Segment
3571: Select flex_value_set_id
3572: Into vl_bal_flex_id
3573: From fnd_id_flex_segments
3574: Where application_id = 101
3575: And application_column_name = v_bal_seg_name
3576: And id_flex_code = 'GL#'
3577: And id_flex_num = vp_coa_id;