APPS.XLA_SEG_RULES_F_PKG dependencies on XLA_SEG_RULES_B

Line 88: FROM xla_seg_rules_b

84: IS
85:
86: CURSOR c IS
87: SELECT rowid
88: FROM xla_seg_rules_b
89: WHERE application_id = x_application_id
90: AND amb_context_code = x_amb_context_code
91: AND segment_rule_type_code = x_segment_rule_type_code
92: AND segment_rule_code = x_segment_rule_code

Line 107: INSERT INTO xla_seg_rules_b

103: p_module => l_log_module,
104: p_level => C_LEVEL_PROCEDURE);
105: END IF;
106:
107: INSERT INTO xla_seg_rules_b
108: (creation_date
109: ,created_by
110: ,amb_context_code
111: ,application_id

Line 230: FROM xla_seg_rules_b

226: ,flexfield_assign_mode_code
227: ,flexfield_segment_code
228: ,enabled_flag
229: ,flex_value_set_id
230: FROM xla_seg_rules_b
231: WHERE application_id = x_application_id
232: AND amb_context_code = x_amb_context_code
233: AND segment_rule_type_code = x_segment_rule_type_code
234: AND segment_rule_code = x_segment_rule_code

Line 355: UPDATE xla_seg_rules_b

351: p_module => l_log_module,
352: p_level => C_LEVEL_PROCEDURE);
353: END IF;
354:
355: UPDATE xla_seg_rules_b
356: SET
357: last_update_date = x_last_update_date
358: ,transaction_coa_id = x_transaction_coa_id
359: ,accounting_coa_id = x_accounting_coa_id

Line 438: DELETE FROM xla_seg_rules_b

434: IF (SQL%NOTFOUND) THEN
435: RAISE NO_DATA_FOUND;
436: END IF;
437:
438: DELETE FROM xla_seg_rules_b
439: WHERE application_id = x_application_id
440: AND amb_context_code = x_amb_context_code
441: AND segment_rule_type_code = x_segment_rule_type_code
442: AND segment_rule_code = x_segment_rule_code;

Line 483: FROM xla_seg_rules_b b

479:
480: DELETE FROM xla_seg_rules_tl T
481: WHERE NOT EXISTS
482: (SELECT NULL
483: FROM xla_seg_rules_b b
484: WHERE b.application_id = t.application_id
485: AND b.amb_context_code = t.amb_context_code
486: AND b.segment_rule_type_code = t.segment_rule_type_code
487: AND b.segment_rule_code = t.segment_rule_code);