APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FND_FLEX_VALUES_TL

Line 1526: FND_FLEX_VALUES_TL T

1522: T.SOURCE_LANG
1523: FROM
1524: ' || p_member_b_table_name || ' M,
1525: FND_FLEX_VALUES B,
1526: FND_FLEX_VALUES_TL T
1527: WHERE
1528: M.VALUE_SET_ID = :p_vs_id AND
1529: T.FLEX_VALUE_ID = M.' || p_member_col || ' AND
1530: B.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND

Line 2890: ,fnd_flex_values_tl TL1';

2886: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).where_clause || ') TL1';
2887: ELSE
2888: v_merge_stmt := v_merge_stmt
2889: ||' ,fnd_flex_values flex1
2890: ,fnd_flex_values_tl TL1';
2891: END IF;
2892:
2893: IF NVL(fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).table_validated_flag,'N') = 'Y'
2894: THEN

Line 2905: ,fnd_flex_values_tl TL2';

2901: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).where_clause || ') TL2';
2902: ELSE
2903: v_merge_stmt := v_merge_stmt
2904: ||' ,fnd_flex_values flex2
2905: ,fnd_flex_values_tl TL2';
2906: END IF;
2907:
2908: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 2
2909: THEN

Line 2922: , fnd_flex_values_tl TL3';

2918: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(3).where_clause || ') TL3';
2919: ELSE
2920: v_merge_stmt := v_merge_stmt
2921: ||',fnd_flex_values flex3
2922: , fnd_flex_values_tl TL3';
2923: END IF;
2924: END IF;
2925:
2926: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 3

Line 2940: , fnd_flex_values_tl TL4';

2936: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(4).where_clause || ') TL4';
2937: ELSE
2938: v_merge_stmt := v_merge_stmt
2939: ||',fnd_flex_values flex4
2940: , fnd_flex_values_tl TL4';
2941: END IF;
2942: END IF;
2943:
2944: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 4

Line 2958: ,fnd_flex_values_tl TL5';

2954: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(5).where_clause || ') TL5';
2955: ELSE
2956: v_merge_stmt := v_merge_stmt
2957: ||',fnd_flex_values flex5
2958: ,fnd_flex_values_tl TL5';
2959: END IF;
2960: END IF;
2961:
2962: v_merge_stmt := v_merge_stmt

Line 3346: ,fnd_flex_values_tl TL

3342: ,pv_user_id
3343: ,SYSDATE
3344: ,pv_login_id
3345: FROM fem_companies_b tab1
3346: ,fnd_flex_values_tl TL
3347: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_com_vs_id
3348: AND tab1.company_id = TL.flex_value_id
3349: AND not exists ( SELECT 'x'
3350: FROM fem_companies_tl tab2

Line 3625: ,fnd_flex_values_tl TL

3621: ,pv_user_id
3622: ,SYSDATE
3623: ,pv_login_id
3624: FROM fem_cost_centers_b tab1
3625: ,fnd_flex_values_tl TL
3626: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3627: AND tab1.cost_center_id = TL.flex_value_id
3628: AND not exists ( SELECT 'x'
3629: FROM fem_cost_centers_tl tab2

Line 4384: fnd_flex_values_tl tl,

4380: USING (SELECT tl.flex_value_id, ffv.flex_value,
4381: tl.description,
4382: tl.language, tl.source_lang
4383: FROM fem_intg_dim_members_gt gt,
4384: fnd_flex_values_tl tl,
4385: fnd_flex_values ffv
4386: WHERE tl.flex_value_id = ffv.flex_value_id
4387: AND ffv.flex_value_set_id = :pv_aol_vs_id
4388: AND ffv.flex_value = gt.concat_segment_value) s