20: WHERE (application_id, id_flex_code,
21: id_flex_num, application_column_name) =
22: (SELECT application_id, id_flex_code,
23: id_flex_num, application_column_name
24: FROM fnd_segment_attribute_values a
25: WHERE application_id = app_id
26: AND id_flex_code = 'GL#'
27: AND id_flex_num = cht_id
28: AND segment_attribute_type = seg_type