APPS.GL_REP_ATTRIBUTES dependencies on FND_FLEX_VALUE_SETS

Line 33: lc_flex_val_set_name fnd_flex_value_sets.flex_value_set_name%type;

29: lval_format fnd_vset.valueset_dr;
30: ---------------------
31: -- Flags and Counters
32: ---------------------
33: lc_flex_val_set_name fnd_flex_value_sets.flex_value_set_name%type;
34: lc_new_flex_flag varchar2(1):='N';
35: ln_no_of_attributes number;
36: ln_func number;
37: ln_gl_nsegs number;

Line 118: fnd_flex_value_sets val ,

114: fdu.default_type ,
115: fdu.default_value ,
116: fdu.range_code
117: FROM fnd_seg_rpt_attributes att,
118: fnd_flex_value_sets val ,
119: fnd_descr_flex_column_usages fdu
120: WHERE segment_name = p_seg_name
121: AND att.attr_value_set_id = val.flex_value_set_id
122: AND att.enabled_flag = 'Y'

Line 705: fnd_flex_value_sets valset

701: attr.segment_num,
702: valset.validation_type,
703: attr.attr_segment_name
704: FROM fnd_seg_rpt_attributes attr,
705: fnd_flex_value_sets valset
706: WHERE valset.flex_value_set_id = attr.flex_value_set_id
707: AND attr.id_flex_num = :ln_p_coa_id ';
708: ELSE
709: lc_select_stmt:=

Line 718: fnd_flex_value_sets valset

714: attr.segment_name,
715: attr.segment_num,
716: valset.validation_type
717: FROM fnd_seg_rpt_attributes attr,
718: fnd_flex_value_sets valset
719: WHERE valset.flex_value_set_id = attr.flex_value_set_id
720: AND attr.id_flex_num = :ln_p_coa_id '||
721: 'AND attr.segment_name = :lc_p_segment_name '||
722: 'AND attr.attr_segment_name = :lc_p_denorm_seg ';

Line 817: FROM fnd_flex_value_sets

813: FROM fnd_id_flex_segments
814: WHERE id_flex_code = 'GLAT'
815: AND flex_value_set_id =
816: (SELECT parent_flex_value_set_id
817: FROM fnd_flex_value_sets
818: WHERE flex_value_set_id = ln_flex_value_set_id);
819: --
820: IF lc_parent_seg_name IS NULL THEN
821: lc_err_message:='The Parent Seg name is null for the Dependent Value Set';