APPS.XLA_AC_BALANCES_PKG dependencies on GL_CODE_COMBINATIONS

Line 593: cp_cc_id gl_code_combinations.code_combination_id%TYPE

589: AND fut_periods.end_date < cp_latest_end_date;
590:
591: -- Get account type for a ccid
592: CURSOR c_account_type(
593: cp_cc_id gl_code_combinations.code_combination_id%TYPE
594: ) IS
595: SELECT account_type
596: FROM gl_code_combinations
597: WHERE code_combination_id = cp_cc_id;

Line 596: FROM gl_code_combinations

592: CURSOR c_account_type(
593: cp_cc_id gl_code_combinations.code_combination_id%TYPE
594: ) IS
595: SELECT account_type
596: FROM gl_code_combinations
597: WHERE code_combination_id = cp_cc_id;
598: l_account_type gl_code_combinations.account_type%TYPE;
599:
600: -- Get period num

Line 598: l_account_type gl_code_combinations.account_type%TYPE;

594: ) IS
595: SELECT account_type
596: FROM gl_code_combinations
597: WHERE code_combination_id = cp_cc_id;
598: l_account_type gl_code_combinations.account_type%TYPE;
599:
600: -- Get period num
601: CURSOR c_period_num(
602: cp_application_id gl_ledgers.ledger_id%TYPE,

Line 1623: ,p_code_comb_id gl_code_combinations.code_combination_id%TYPE) IS

1619: --
1620: --=============================================================================
1621: CURSOR c_is_valid_code_comb_id(
1622: p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1623: ,p_code_comb_id gl_code_combinations.code_combination_id%TYPE) IS
1624: select 1
1625: from gl_ledgers lg,
1626: gl_code_combinations cc
1627: where lg.ledger_id = p_ledger_id

Line 1626: gl_code_combinations cc

1622: p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1623: ,p_code_comb_id gl_code_combinations.code_combination_id%TYPE) IS
1624: select 1
1625: from gl_ledgers lg,
1626: gl_code_combinations cc
1627: where lg.ledger_id = p_ledger_id
1628: and lg.chart_of_accounts_id = cc.chart_of_accounts_id
1629: and cc.code_combination_id = p_code_comb_id;
1630:

Line 1638: from gl_code_combinations gl

1634: --
1635: --=============================================================================
1636: CURSOR c_is_valid_pop_code_comb_id(p_rec xla_ac_balances_int%ROWTYPE) IS
1637: select gl.code_combination_id
1638: from gl_code_combinations gl
1639: where NVL(gl.segment1, 'X') = NVL(p_rec.segment1, 'X')
1640: and NVL(gl.segment2, 'X') = NVL(p_rec.segment2, 'X')
1641: and NVL(gl.segment3, 'X') = NVL(p_rec.segment3, 'X')
1642: and NVL(gl.segment4, 'X') = NVL(p_rec.segment4, 'X')