DBA Data[Home] [Help]

APPS.XLA_AMB_AAD_PKG dependencies on XLA_ANALYTICAL_SOURCES

Line 1177: FROM xla_analytical_sources a

1173: AND s.amb_context_code = p_amb_context_code
1174: AND s.product_rule_type_code = p_product_rule_type_code
1175: AND s.product_rule_code = p_product_rule_code
1176: AND NOT EXISTS (SELECT 'x'
1177: FROM xla_analytical_sources a
1178: WHERE a.application_id = s.application_id
1179: AND a.amb_context_code = s.amb_context_code
1180: AND a.event_class_code = s.event_class_code
1181: AND a.analytical_criterion_code = s.analytical_criterion_code

Line 1190: FROM xla_analytical_sources a, xla_aad_header_ac_assgns n

1186: CURSOR c_hdr_anal_sources IS
1187: SELECT distinct n.event_class_code, n.event_type_code,
1188: n.analytical_criterion_type_code, n.analytical_criterion_code,
1189: a.source_code, a.source_type_code
1190: FROM xla_analytical_sources a, xla_aad_header_ac_assgns n
1191: WHERE a.application_id = n.application_id
1192: AND a.amb_context_code = n.amb_context_code
1193: AND a.event_class_code = n.event_class_code
1194: AND a.analytical_criterion_code = n.analytical_criterion_code

Line 1218: FROM xla_analytical_sources a, xla_aad_header_ac_assgns n

1214: CURSOR c_hdr_anal_der_sources IS
1215: SELECT distinct n.event_class_code, n.event_type_code,
1216: n.analytical_criterion_type_code, n.analytical_criterion_code,
1217: a.source_code, a.source_type_code
1218: FROM xla_analytical_sources a, xla_aad_header_ac_assgns n
1219: WHERE a.application_id = n.application_id
1220: AND a.amb_context_code = n.amb_context_code
1221: AND a.event_class_code = n.event_class_code
1222: AND a.analytical_criterion_code = n.analytical_criterion_code