DBA Data[Home] [Help]

APPS.XLA_SEG_RULES_PKG dependencies on XLA_SEG_RULE_DETAILS_S

Line 261: SELECT xla_seg_rule_details_s.nextval

257: -- value_flexfield_segment_code is null
258: l_value_flexfield_segment_code := l_seg_rule_detail.value_flexfield_segment_code;
259: END IF;
260:
261: SELECT xla_seg_rule_details_s.nextval
262: INTO l_new_segment_rule_detail_id
263: FROM DUAL;
264:
265: INSERT INTO xla_seg_rule_details

Line 1309: FROM xla_seg_rule_details seg

1305:
1306: CURSOR c_flex_value
1307: IS
1308: SELECT value_constant
1309: FROM xla_seg_rule_details seg
1310: WHERE application_id = p_application_id
1311: AND amb_context_code = p_amb_context_code
1312: AND segment_rule_type_code = p_old_segment_rule_type_code
1313: AND segment_rule_code = p_old_segment_rule_code

Line 1672: FROM xla_seg_rule_details s

1668: SELECT application_id
1669: ,amb_context_code
1670: ,segment_rule_type_code
1671: ,segment_rule_code
1672: FROM xla_seg_rule_details s
1673: WHERE value_segment_rule_appl_id = p_application_id
1674: AND value_segment_rule_type_code = p_segment_rule_type_code
1675: AND value_segment_rule_code = p_segment_rule_code;
1676: