APPS.PSA_REP_ATTRIBUTES dependencies on FND_SEG_RPT_ATTRIBUTES

Line 163: FROM fnd_seg_rpt_attributes att,

159: att.segment_name,
160: fdu.default_type ,
161: fdu.default_value ,
162: fdu.range_code
163: FROM fnd_seg_rpt_attributes att,
164: fnd_flex_value_sets val ,
165: fnd_descr_flex_column_usages fdu
166: WHERE segment_name = p_seg_name
167: AND att.attr_value_set_id = val.flex_value_set_id

Line 252: FROM fnd_seg_rpt_attributes

248: END IF;
249: --
250: SELECT COUNT(*)
251: INTO ln_no_of_attributes
252: FROM fnd_seg_rpt_attributes
253: WHERE application_id = 101
254: AND id_flex_code = 'GLAT'
255: AND id_flex_num = p_coa_id;
256: debug (l_module_name, 'ln_no_of_attributes='||ln_no_of_attributes);

Line 1112: FROM fnd_seg_rpt_attributes attr,

1108: attr.segment_name,
1109: attr.segment_num,
1110: valset.validation_type,
1111: attr.attr_segment_name
1112: FROM fnd_seg_rpt_attributes attr,
1113: fnd_flex_value_sets valset
1114: WHERE valset.flex_value_set_id = attr.flex_value_set_id
1115: AND attr.id_flex_num = :ln_p_coa_id ';
1116: ELSE

Line 1125: FROM fnd_seg_rpt_attributes attr,

1121: attr.application_column_name,
1122: attr.segment_name,
1123: attr.segment_num,
1124: valset.validation_type
1125: FROM fnd_seg_rpt_attributes attr,
1126: fnd_flex_value_sets valset
1127: WHERE valset.flex_value_set_id = attr.flex_value_set_id
1128: AND attr.id_flex_num = :ln_p_coa_id '||
1129: 'AND attr.segment_name = :lc_p_segment_name '||