APPS.XLA_TAB_ACCT_DEFS_PKG dependencies on XLA_SEG_RULE_DETAILS

Line 51: FROM xla_seg_rule_details d

47:
48: CURSOR c_seg_details
49: IS
50: SELECT 'x'
51: FROM xla_seg_rule_details d
52: WHERE application_id = p_application_id
53: AND amb_context_code = p_amb_context_code
54: AND segment_rule_type_code = p_segment_rule_type_code
55: AND segment_rule_code = p_segment_rule_code;

Line 60: FROM xla_seg_rule_details d

56:
57: CURSOR c_seg_value_sources
58: IS
59: SELECT value_source_type_code source_type_code, value_source_code source_code
60: FROM xla_seg_rule_details d
61: WHERE application_id = p_application_id
62: AND amb_context_code = p_amb_context_code
63: AND segment_rule_type_code = p_segment_rule_type_code
64: AND segment_rule_code = p_segment_rule_code

Line 76: FROM xla_seg_rule_details d

72: AND s.application_id = p_application_id
73: AND s.account_type_code = p_account_type_code)
74: UNION
75: SELECT input_source_type_code source_type_code, input_source_code source_code
76: FROM xla_seg_rule_details d
77: WHERE application_id = p_application_id
78: AND amb_context_code = p_amb_context_code
79: AND segment_rule_type_code = p_segment_rule_type_code
80: AND segment_rule_code = p_segment_rule_code

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 134: FROM xla_seg_rule_details d

130:
131: CURSOR c_seg_value_der_sources
132: IS
133: SELECT value_source_type_code source_type_code, value_source_code source_code
134: FROM xla_seg_rule_details d
135: WHERE application_id = p_application_id
136: AND amb_context_code = p_amb_context_code
137: AND segment_rule_type_code = p_segment_rule_type_code
138: AND segment_rule_code = p_segment_rule_code

Line 143: FROM xla_seg_rule_details d

139: AND value_source_code is not null
140: AND value_source_type_code = 'D'
141: UNION
142: SELECT input_source_type_code source_type_code, input_source_code source_code
143: FROM xla_seg_rule_details d
144: WHERE application_id = p_application_id
145: AND amb_context_code = p_amb_context_code
146: AND segment_rule_type_code = p_segment_rule_type_code
147: AND segment_rule_code = p_segment_rule_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