APPS.XLA_MAPPING_SETS_PKG dependencies on XLA_SEG_RULE_DETAILS

Line 82: FROM xla_seg_rule_details

78:
79: CURSOR c_assignment_exist
80: IS
81: SELECT application_id, amb_context_code, segment_rule_code, segment_rule_type_code
82: FROM xla_seg_rule_details
83: WHERE value_mapping_set_code = p_mapping_set_code
84: AND amb_context_code = p_amb_context_code
85: AND value_mapping_set_code is not null;
86:

Line 166: FROM xla_seg_rule_details xsr

162:
163: CURSOR c_frozen_assignment_exist
164: IS
165: SELECT 'x'
166: FROM xla_seg_rule_details xsr
167: WHERE xsr.value_mapping_set_code = p_mapping_set_code
168: AND xsr.amb_context_code = p_amb_context_code
169: AND xsr.value_mapping_set_code is not null
170: AND exists (SELECT 'x'

Line 195: FROM xla_seg_rule_details d

191:
192: CURSOR c_tab_assignment_exist
193: IS
194: SELECT 'x'
195: FROM xla_seg_rule_details d
196: WHERE d.value_mapping_set_code = p_mapping_set_code
197: AND d.amb_context_code = p_amb_context_code
198: AND d.value_mapping_set_code is not null
199: AND exists (SELECT 'x'

Line 347: FROM xla_seg_rule_details d

343:
344: CURSOR c_prod_rules
345: IS
346: SELECT application_id, amb_context_code, segment_rule_type_code, segment_rule_code
347: FROM xla_seg_rule_details d
348: WHERE d.value_mapping_set_code = p_mapping_set_code
349: AND d.value_mapping_set_code is not null;
350:
351: l_prod_rule c_prod_rules%rowtype;

Line 441: FROM xla_seg_rule_details d

437: CURSOR c_prod_rules
438: IS
439: SELECT application_id, amb_context_code,
440: segment_rule_type_code, segment_rule_code
441: FROM xla_seg_rule_details d
442: WHERE d.value_mapping_set_code = p_mapping_set_code
443: AND d.value_mapping_set_code is not null;
444:
445: