APPS.PSA_REP_ATTRIBUTES dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 121: FROM fnd_segment_attribute_values val,

117: typ.global_flag global_flag,
118: typ.required_flag required_flag,
119: typ.unique_flag unique_flag,
120: val.attribute_value attribute_value
121: FROM fnd_segment_attribute_values val,
122: fnd_segment_attribute_types typ
123: WHERE val.id_flex_num =p_id_flex_num -- Bug 3813504
124: AND val.id_flex_code = p_id_flex_code
125: AND val.id_flex_code = typ.id_flex_code

Line 625: debug (l_module_name, 'Updating fnd_segment_attribute_values for '||cv_del_seg_attr_cur.segment_attribute_type);

621: FOR cv_del_seg_attr_cur IN seg_attr_cur(p_coa_id,
622: 'GLLE',
623: 101,
624: lseg_gl_segs.column_name) LOOP
625: debug (l_module_name, 'Updating fnd_segment_attribute_values for '||cv_del_seg_attr_cur.segment_attribute_type);
626: UPDATE fnd_segment_attribute_values sav
627: SET sav.attribute_value = 'N'
628: WHERE sav.application_id = 101
629: AND sav.id_flex_code = 'GLAT'

Line 626: UPDATE fnd_segment_attribute_values sav

622: 'GLLE',
623: 101,
624: lseg_gl_segs.column_name) LOOP
625: debug (l_module_name, 'Updating fnd_segment_attribute_values for '||cv_del_seg_attr_cur.segment_attribute_type);
626: UPDATE fnd_segment_attribute_values sav
627: SET sav.attribute_value = 'N'
628: WHERE sav.application_id = 101
629: AND sav.id_flex_code = 'GLAT'
630: AND sav.attribute_value = 'Y'