1093:
1094: BEGIN
1095: SELECT application_column_name
1096: INTO l_balance_segment
1097: FROM fnd_segment_attribute_values
1098: WHERE application_id = 101
1099: AND id_flex_code = 'GL#'
1100: AND id_flex_num = p_coa_id
1101: AND attribute_value = 'Y'
1107:
1108: BEGIN
1109: SELECT application_column_name
1110: INTO l_account_segment
1111: FROM fnd_segment_attribute_values
1112: WHERE application_id = 101
1113: AND id_flex_code = 'GL#'
1114: AND id_flex_num = p_coa_id
1115: AND attribute_value = 'Y'
1121:
1122: BEGIN
1123: SELECT application_column_name
1124: INTO l_cost_center_segment
1125: FROM fnd_segment_attribute_values
1126: WHERE application_id = 101
1127: AND id_flex_code = 'GL#'
1128: AND id_flex_num = p_coa_id
1129: AND attribute_value = 'Y'
1135:
1136: BEGIN
1137: SELECT application_column_name
1138: INTO l_management_segment
1139: FROM fnd_segment_attribute_values
1140: WHERE application_id = 101
1141: AND id_flex_code = 'GL#'
1142: AND id_flex_num = p_coa_id
1143: AND attribute_value = 'Y'
1149:
1150: BEGIN
1151: SELECT application_column_name
1152: INTO l_intercompany_segment
1153: FROM fnd_segment_attribute_values
1154: WHERE application_id = 101
1155: AND id_flex_code = 'GL#'
1156: AND id_flex_num = p_coa_id
1157: AND attribute_value = 'Y'