eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AMB_AAD_PKG dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 1138: FROM xla_aad_header_ac_assgns s

1134: -- Get all header analytical criteria for the AAD that are disabled
1135: CURSOR c_enabled_hdr_anal IS
1136: SELECT distinct s.event_class_code, s.event_type_code,
1137: s.analytical_criterion_type_code, s.analytical_criterion_code
1138: FROM xla_aad_header_ac_assgns s
1139: WHERE s.application_id = p_application_id
1140: AND s.amb_context_code = p_amb_context_code
1141: AND s.product_rule_type_code = p_product_rule_type_code
1142: AND s.product_rule_code = p_product_rule_code

Line 1154: FROM xla_aad_header_ac_assgns s

1150: -- Get all header analytical criteria for the AAD that have balancing flag set
1151: CURSOR c_hdr_anal IS
1152: SELECT distinct s.event_class_code, s.event_type_code,
1153: s.analytical_criterion_type_code, s.analytical_criterion_code
1154: FROM xla_aad_header_ac_assgns s
1155: WHERE s.application_id = p_application_id
1156: AND s.amb_context_code = p_amb_context_code
1157: AND s.product_rule_type_code = p_product_rule_type_code
1158: AND s.product_rule_code = p_product_rule_code

Line 1171: FROM xla_aad_header_ac_assgns s

1167: -- for the event class
1168: CURSOR c_hdr_event_sources IS
1169: SELECT distinct s.event_class_code, s.event_type_code,
1170: s.analytical_criterion_type_code, s.analytical_criterion_code
1171: FROM xla_aad_header_ac_assgns s
1172: WHERE s.application_id = p_application_id
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

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