APPS.XLA_AC_BALANCES_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 461: FROM xla_analytical_hdrs_b xah

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

Line 1677: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE

1673: -- Cursor to validate analytical criterion code
1674: --
1675: --=============================================================================
1676: CURSOR c_is_valid_anal_crit_code
1677: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1678: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1679: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1680: SELECT 1
1681: FROM XLA_ANALYTICAL_HDRS_B

Line 1678: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE

1674: --
1675: --=============================================================================
1676: CURSOR c_is_valid_anal_crit_code
1677: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1678: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1679: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1680: SELECT 1
1681: FROM XLA_ANALYTICAL_HDRS_B
1682: WHERE analytical_criterion_code = p_anal_crit_code

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

1675: --=============================================================================
1676: CURSOR c_is_valid_anal_crit_code
1677: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1678: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1679: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1680: SELECT 1
1681: FROM XLA_ANALYTICAL_HDRS_B
1682: WHERE analytical_criterion_code = p_anal_crit_code
1683: AND analytical_criterion_type_code = p_anal_crit_type_code

Line 1681: FROM XLA_ANALYTICAL_HDRS_B

1677: (p_anal_crit_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_code%TYPE
1678: ,p_anal_crit_type_code XLA_ANALYTICAL_HDRS_B.analytical_criterion_type_code%TYPE
1679: ,p_amb_context_code XLA_ANALYTICAL_HDRS_B.amb_context_code%TYPE) IS
1680: SELECT 1
1681: FROM XLA_ANALYTICAL_HDRS_B
1682: WHERE analytical_criterion_code = p_anal_crit_code
1683: AND analytical_criterion_type_code = p_anal_crit_type_code
1684: AND amb_context_code = p_amb_context_code
1685: AND balancing_flag = 'Y'