1433: AND s.id_flex_num = pn_coa_id
1434: AND s.id_flex_code = 'GL#'
1435: AND s.application_column_name =
1436: (SELECT application_column_name
1437: FROM fnd_segment_attribute_values
1438: WHERE application_id = 101
1439: AND segment_attribute_type = 'GL_ACCOUNT'
1440: AND attribute_value = 'Y'
1441: AND id_flex_num = pn_coa_id