APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 1004: FROM xla_analytical_hdrs_b xah

1000: END IF;
1001:
1002: SELECT xah.balancing_flag
1003: INTO l_balancing_flag
1004: FROM xla_analytical_hdrs_b xah
1005: WHERE xah.analytical_criterion_code = p_anacri_code
1006: AND xah.analytical_criterion_type_code = p_anacri_type_code
1007: AND xah.amb_context_code = p_amb_context_code
1008: AND xah.enabled_flag = 'Y';

Line 1013: ,p_msg => 'balancing_flag from xla_analytical_hdrs_b:'

1009:
1010: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1011: trace
1012: ( p_module => l_log_module
1013: ,p_msg => 'balancing_flag from xla_analytical_hdrs_b:'
1014: || l_balancing_flag
1015: ,p_level => C_LEVEL_STATEMENT);
1016: END IF;
1017:

Line 1279: FROM xla_analytical_hdrs_b xah

1275: END IF;
1276:
1277: SELECT xah.balancing_flag
1278: INTO l_balancing_flag
1279: FROM xla_analytical_hdrs_b xah
1280: WHERE xah.analytical_criterion_code = p_anacri_code
1281: AND xah.analytical_criterion_type_code = p_anacri_type_code
1282: AND xah.amb_context_code = p_amb_context_code
1283: AND xah.enabled_flag = 'Y';

Line 1288: ,p_msg => 'balancing_flag from xla_analytical_hdrs_b:'

1284:
1285: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1286: trace
1287: ( p_module => l_log_module
1288: ,p_msg => 'balancing_flag from xla_analytical_hdrs_b:'
1289: || l_balancing_flag
1290: ,p_level => C_LEVEL_STATEMENT);
1291: END IF;
1292:

Line 1785: ,xla_analytical_hdrs_b xahb

1781: (
1782: SELECT count(xald.ae_line_num)
1783: FROM xla_ae_line_details xald
1784: ,xla_analytical_dtl_vals xadv
1785: ,xla_analytical_hdrs_b xahb
1786: WHERE xald.ae_header_id = p_ae_header_id
1787: AND xald.ae_line_num = p_ae_line_num
1788: AND xadv.analytical_detail_value_id = xald.analytical_detail_value_id
1789: AND xahb.amb_context_code = xadv.amb_context_code

Line 2164: ,xla_analytical_hdrs_b xahb

2160: AND 0 =
2161: (
2162: SELECT count(xald.ae_line_num)
2163: FROM xla_ae_line_acs xald
2164: ,xla_analytical_hdrs_b xahb
2165: WHERE xald.ae_header_id = p_ae_header_id
2166: AND xald.ae_line_num = p_ae_line_num
2167: AND xahb.amb_context_code = xald.amb_context_code
2168: AND xahb.analytical_criterion_code = xald.analytical_criterion_code

Line 3857: ,xla_analytical_hdrs_b xhtb

3853: )
3854: IS
3855: SELECT xdtb.view_column_num
3856: FROM xla_analytical_dtls_b xdtb
3857: ,xla_analytical_hdrs_b xhtb
3858: WHERE xdtb.analytical_criterion_code = xhtb.analytical_criterion_code
3859: AND xdtb.analytical_criterion_type_code = xhtb.analytical_criterion_type_code
3860: AND xhtb.balancing_flag = p_balance_flag
3861: AND xdtb.data_type_code = cp_data_type_code

Line 3866: ,xla_analytical_hdrs_b xhtb2

3862: AND NVL(xdtb.view_column_num, -1) =
3863: (SELECT NVL( MIN(xdtb2.view_column_num), -1)
3864: FROM xla_analytical_dtls_b xdtb2
3865: ,xla_analytical_dtls_b xdtb3
3866: ,xla_analytical_hdrs_b xhtb2
3867: WHERE xdtb2.data_type_code = xdtb.data_type_code
3868: AND xdtb2.analytical_criterion_code = xhtb2.analytical_criterion_code
3869: AND xdtb2.analytical_criterion_type_code = xhtb2.analytical_criterion_type_code
3870: AND xhtb2.balancing_flag = p_balance_flag

Line 4163: FROM xla_analytical_hdrs_b xhdb

4159: ,xhdb.balancing_flag
4160: INTO l_enabled_flag
4161: ,l_display_in_inquiries_flag
4162: ,l_balance_flag
4163: FROM xla_analytical_hdrs_b xhdb
4164: WHERE xhdb.analytical_criterion_code = p_anacri_code
4165: AND xhdb.analytical_criterion_type_code = p_anacri_type_code
4166: AND xhdb.amb_context_code = p_amb_context_code
4167: FOR UPDATE NOWAIT;

Line 4387: FROM xla_analytical_hdrs_b xhdb

4383: --,xhdb.amb_context_code
4384: ,xdtb.analytical_detail_code
4385: ,xdtb.grouping_order
4386: ,xdtb.view_column_num
4387: FROM xla_analytical_hdrs_b xhdb
4388: ,xla_analytical_dtls_b xdtb
4389: WHERE xhdb.display_in_inquiries_flag = 'Y'
4390: AND xdtb.analytical_criterion_code = xhdb.analytical_criterion_code
4391: AND xdtb.analytical_criterion_type_code = xhdb.analytical_criterion_type_code