156:
157: CURSOR c_input_source
158: IS
159: SELECT flexfield_application_id, id_flex_code
160: FROM xla_sources_b
161: WHERE application_id = l_seg_rule_detail.input_source_application_id
162: AND source_type_code = l_seg_rule_detail.input_source_type_code
163: AND source_code = l_seg_rule_detail.input_source_code;
164:
178:
179: CURSOR c_source
180: IS
181: SELECT flexfield_application_id, id_flex_code
182: FROM xla_sources_b
183: WHERE application_id = l_detail_condition.source_application_id
184: AND source_type_code = l_detail_condition.source_type_code
185: AND source_code = l_detail_condition.source_code;
186:
186:
187: CURSOR c_value_source
188: IS
189: SELECT flexfield_application_id, id_flex_code
190: FROM xla_sources_b
191: WHERE application_id = l_detail_condition.value_source_application_id
192: AND source_type_code = l_detail_condition.value_source_type_code
193: AND source_code = l_detail_condition.value_source_code;
194:
1336:
1337: CURSOR c_input_source
1338: IS
1339: SELECT flexfield_application_id, id_flex_code
1340: FROM xla_sources_b
1341: WHERE application_id = l_seg_rule_detail.input_source_application_id
1342: AND source_type_code = l_seg_rule_detail.input_source_type_code
1343: AND source_code = l_seg_rule_detail.input_source_code;
1344:
1357:
1358: CURSOR c_source
1359: IS
1360: SELECT flexfield_application_id, id_flex_code
1361: FROM xla_sources_b
1362: WHERE application_id = l_detail_condition.source_application_id
1363: AND source_type_code = l_detail_condition.source_type_code
1364: AND source_code = l_detail_condition.source_code;
1365:
1365:
1366: CURSOR c_value_source
1367: IS
1368: SELECT flexfield_application_id, id_flex_code
1369: FROM xla_sources_b
1370: WHERE application_id = l_detail_condition.value_source_application_id
1371: AND source_type_code = l_detail_condition.value_source_type_code
1372: AND source_code = l_detail_condition.value_source_code;
1373: