APPS.XLA_TAB_ACCT_DEFS_PKG dependencies on XLA_CONDITIONS

Line 96: FROM xla_conditions c, xla_seg_rule_details d

92:
93: CURSOR c_seg_condition_sources
94: IS
95: SELECT c.source_type_code, c.source_code
96: FROM xla_conditions c, xla_seg_rule_details d
97: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
98: AND d.application_id = p_application_id
99: AND d.amb_context_code = p_amb_context_code
100: AND d.segment_rule_type_code = p_segment_rule_type_code

Line 113: FROM xla_conditions c, xla_seg_rule_details d

109: AND s.application_id = p_application_id
110: AND s.account_type_code = p_account_type_code)
111: UNION
112: SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
113: FROM xla_conditions c, xla_seg_rule_details d
114: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
115: AND d.application_id = p_application_id
116: AND d.amb_context_code = p_amb_context_code
117: AND d.segment_rule_type_code = p_segment_rule_type_code

Line 156: FROM xla_conditions c, xla_seg_rule_details d

152:
153: CURSOR c_seg_condition_der_sources
154: IS
155: SELECT c.source_type_code source_type_code, c.source_code source_code
156: FROM xla_conditions c, xla_seg_rule_details d
157: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
158: AND d.application_id = p_application_id
159: AND d.amb_context_code = p_amb_context_code
160: AND d.segment_rule_type_code = p_segment_rule_type_code

Line 166: FROM xla_conditions c, xla_seg_rule_details d

162: AND c.source_code is not null
163: AND c.source_type_code = 'D'
164: UNION
165: SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
166: FROM xla_conditions c, xla_seg_rule_details d
167: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
168: AND d.application_id = p_application_id
169: AND d.amb_context_code = p_amb_context_code
170: AND d.segment_rule_type_code = p_segment_rule_type_code