APPS.XLA_AC_BALANCES_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 459: FROM xla_analytical_hdrs_b xah

455: cp_criterion_type_code xla_ac_balances.analytical_criterion_type_code%TYPE
456: ) IS
457: SELECT NVL(xah.balancing_flag,'N') balancing_flag,
458: xah.year_end_carry_forward_code
459: FROM xla_analytical_hdrs_b xah
460: WHERE xah.amb_context_code = cp_amb_context_code
461: AND xah.analytical_criterion_code = cp_analytical_criterion_code
462: AND xah.analytical_criterion_type_code = cp_criterion_type_code;
463: l_sup_ref_hdr c_sup_ref_hdr%ROWTYPE;

Line 1669: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE

1665: -- Cursor to validate analytical criterion code
1666: --
1667: --=============================================================================
1668: CURSOR c_is_valid_anal_crit_code
1669: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1670: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1671: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1672: SELECT 1
1673: FROM XLA_ANALYTICAL_HDRS_B

Line 1670: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE

1666: --
1667: --=============================================================================
1668: CURSOR c_is_valid_anal_crit_code
1669: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1670: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1671: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1672: SELECT 1
1673: FROM XLA_ANALYTICAL_HDRS_B
1674: WHERE analytical_criterion_code = p_anal_crit_code

Line 1671: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS

1667: --=============================================================================
1668: CURSOR c_is_valid_anal_crit_code
1669: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1670: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1671: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1672: SELECT 1
1673: FROM XLA_ANALYTICAL_HDRS_B
1674: WHERE analytical_criterion_code = p_anal_crit_code
1675: AND analytical_criterion_type_code = p_anal_crit_type_code

Line 1673: FROM XLA_ANALYTICAL_HDRS_B

1669: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1670: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1671: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1672: SELECT 1
1673: FROM XLA_ANALYTICAL_HDRS_B
1674: WHERE analytical_criterion_code = p_anal_crit_code
1675: AND analytical_criterion_type_code = p_anal_crit_type_code
1676: AND amb_context_code = p_amb_context_code
1677: AND balancing_flag = 'Y'