APPS.XLA_AC_BALANCES_PKG dependencies on GL_CODE_COMBINATIONS

Line 588: cp_cc_id gl_code_combinations.code_combination_id%TYPE

584: AND fut_periods.end_date < cp_latest_end_date;
585:
586: -- Get account type for a ccid
587: CURSOR c_account_type(
588: cp_cc_id gl_code_combinations.code_combination_id%TYPE
589: ) IS
590: SELECT account_type
591: FROM gl_code_combinations
592: WHERE code_combination_id = cp_cc_id;

Line 591: FROM gl_code_combinations

587: CURSOR c_account_type(
588: cp_cc_id gl_code_combinations.code_combination_id%TYPE
589: ) IS
590: SELECT account_type
591: FROM gl_code_combinations
592: WHERE code_combination_id = cp_cc_id;
593: l_account_type gl_code_combinations.account_type%TYPE;
594:
595: -- Get period num

Line 593: l_account_type gl_code_combinations.account_type%TYPE;

589: ) IS
590: SELECT account_type
591: FROM gl_code_combinations
592: WHERE code_combination_id = cp_cc_id;
593: l_account_type gl_code_combinations.account_type%TYPE;
594:
595: -- Get period num
596: CURSOR c_period_num(
597: cp_application_id gl_ledgers.ledger_id%TYPE,

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

1611: --
1612: --=============================================================================
1613: CURSOR c_is_valid_code_comb_id(
1614: p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1615: ,p_code_comb_id gl_code_combinations.code_combination_id%TYPE) IS
1616: select 1
1617: from gl_ledgers lg,
1618: gl_code_combinations cc
1619: where lg.ledger_id = p_ledger_id

Line 1618: gl_code_combinations cc

1614: p_ledger_id xla_ac_balances_int.ledger_id%TYPE
1615: ,p_code_comb_id gl_code_combinations.code_combination_id%TYPE) IS
1616: select 1
1617: from gl_ledgers lg,
1618: gl_code_combinations cc
1619: where lg.ledger_id = p_ledger_id
1620: and lg.chart_of_accounts_id = cc.chart_of_accounts_id
1621: and cc.code_combination_id = p_code_comb_id;
1622:

Line 1630: from gl_code_combinations gl

1626: --
1627: --=============================================================================
1628: CURSOR c_is_valid_pop_code_comb_id(p_rec xla_ac_balances_int%ROWTYPE) IS
1629: select gl.code_combination_id
1630: from gl_code_combinations gl
1631: where NVL(gl.segment1, 'X') = NVL(p_rec.segment1, 'X')
1632: and NVL(gl.segment2, 'X') = NVL(p_rec.segment2, 'X')
1633: and NVL(gl.segment3, 'X') = NVL(p_rec.segment3, 'X')
1634: and NVL(gl.segment4, 'X') = NVL(p_rec.segment4, 'X')