eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AC_BALANCES_PKG dependencies on GL_LEDGERS

Line 412: gl_ledgers ledger,

408: cp_period_name xla_ac_balances.period_name%TYPE
409: ) IS
410: SELECT xab.*
411: FROM xla_ac_balances xab,
412: gl_ledgers ledger,
413: gl_periods fut_periods,
414: gl_period_types period_types,
415: gl_period_statuses fut_period_statuses,
416: gl_period_sets period_sets

Line 469: cp_ledger_id gl_ledgers.ledger_id%TYPE,

465: l_period_year xla_ac_balances.period_year%TYPE := NULL;
466:
467: -- Get current period end date
468: CURSOR c_current_period_end_date(
469: cp_ledger_id gl_ledgers.ledger_id%TYPE,
470: cp_application_id gl_period_statuses.application_id%TYPE,
471: cp_period_name gl_periods.period_name%TYPE,
472: cp_period_year gl_periods.period_year%TYPE
473: ) IS

Line 475: FROM gl_ledgers ledger,

471: cp_period_name gl_periods.period_name%TYPE,
472: cp_period_year gl_periods.period_year%TYPE
473: ) IS
474: SELECT periods.end_date
475: FROM gl_ledgers ledger,
476: gl_periods periods,
477: gl_period_types period_types,
478: gl_period_statuses period_statuses,
479: gl_period_sets period_sets

Line 515: gl_ledgers ledger,

511: cp_period_name xla_ac_balances.period_name%TYPE
512: ) IS
513: SELECT periods.start_date
514: FROM xla_ac_balances xab,
515: gl_ledgers ledger,
516: gl_periods periods,
517: gl_period_types period_types,
518: gl_period_statuses period_statuses,
519: gl_period_sets period_sets

Line 564: FROM gl_ledgers ledger,

560: ) IS
561: SELECT fut_periods.period_name,
562: fut_periods.period_year,
563: fut_periods.period_num
564: FROM gl_ledgers ledger,
565: gl_periods fut_periods,
566: gl_period_types period_types,
567: gl_period_statuses fut_period_statuses,
568: gl_period_sets period_sets

Line 597: cp_application_id gl_ledgers.ledger_id%TYPE,

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,
598: cp_period_name gl_periods.period_name%TYPE
599: ) IS
600: SELECT periods.period_num
601: FROM gl_periods periods,

Line 602: gl_ledgers ledger

598: cp_period_name gl_periods.period_name%TYPE
599: ) IS
600: SELECT periods.period_num
601: FROM gl_periods periods,
602: gl_ledgers ledger
603: WHERE ledger.ledger_id = cp_application_id
604: AND ledger.period_set_name = periods.period_set_name
605: AND periods.period_name = cp_period_name;
606: l_period_num gl_periods.period_num%TYPE;

Line 611: cp_ledger_id gl_ledgers.ledger_id%TYPE,

607:
608:
609: CURSOR c_future_open_periods(
610: cp_application_id xla_ac_balances.application_id%TYPE,
611: cp_ledger_id gl_ledgers.ledger_id%TYPE,
612: cp_period_name gl_periods.period_name%TYPE,
613: cp_period_year gl_periods.period_year%TYPE
614: ) IS
615: SELECT fut_periods.period_name,

Line 617: FROM gl_ledgers ledger,

613: cp_period_year gl_periods.period_year%TYPE
614: ) IS
615: SELECT fut_periods.period_name,
616: fut_periods.period_num
617: FROM gl_ledgers ledger,
618: gl_periods fut_periods,
619: gl_period_types period_types,
620: gl_period_statuses fut_period_statuses,
621: gl_period_sets period_sets,

Line 646: cp_ledger_id gl_ledgers.ledger_id%TYPE,

642: l_future_open_periods c_future_open_periods%ROWTYPE;
643:
644: CURSOR c_closed_periods(
645: cp_application_id xla_ac_balances.application_id%TYPE,
646: cp_ledger_id gl_ledgers.ledger_id%TYPE,
647: cp_period_name gl_periods.period_name%TYPE,
648: cp_period_year gl_periods.period_year%TYPE
649: ) IS
650: SELECT fut_periods.period_name,

Line 652: FROM gl_ledgers ledger,

648: cp_period_year gl_periods.period_year%TYPE
649: ) IS
650: SELECT fut_periods.period_name,
651: fut_periods.period_num
652: FROM gl_ledgers ledger,
653: gl_periods fut_periods,
654: gl_period_types period_types,
655: gl_period_statuses fut_period_statuses,
656: gl_period_sets period_sets,

Line 702: gl_ledgers ledger,

698: cp_period_year xla_ac_balances.period_year%TYPE
699: ) IS
700: SELECT xab.*
701: FROM xla_ac_balances xab,
702: gl_ledgers ledger,
703: gl_periods fut_periods,
704: gl_period_types period_types,
705: gl_period_statuses fut_period_statuses,
706: gl_period_sets period_sets

Line 1557: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

1553: l_result boolean :=true;
1554: l_rec xla_ac_balances_int%ROWTYPE := p_balances_int_rec;
1555: l_test_value NUMBER;
1556: l_error_codes xla_ac_balances_int.message_codes%TYPE;
1557: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
1558: l_code_comb_id xla_ac_balances_int.code_combination_id%TYPE;
1559: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
1560:
1561: x_err_msg VARCHAR2(1000);

Line 1559: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

1555: l_test_value NUMBER;
1556: l_error_codes xla_ac_balances_int.message_codes%TYPE;
1557: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
1558: l_code_comb_id xla_ac_balances_int.code_combination_id%TYPE;
1559: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
1560:
1561: x_err_msg VARCHAR2(1000);
1562: x_ccid NUMBER := 0;
1563: x_templgrid NUMBER := 0;

Line 1584: from gl_ledgers

1580: --
1581: --=============================================================================
1582: CURSOR c_is_valid_ledger(p_ledger_id xla_ac_balances_int.ledger_id%TYPE) IS
1583: select ledger_category_code
1584: from gl_ledgers
1585: where ledger_id = p_ledger_id;
1586:
1587: --=============================================================================
1588: --

Line 1605: from gl_ledgers

1601: --
1602: --=============================================================================
1603: CURSOR c_fetch_coa_id(p_ledger_id xla_ac_balances_int.ledger_id%TYPE) IS
1604: select chart_of_accounts_id
1605: from gl_ledgers
1606: where ledger_id = p_ledger_id;
1607:
1608: --=============================================================================
1609: --

Line 1617: from gl_ledgers lg,

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
1620: and lg.chart_of_accounts_id = cc.chart_of_accounts_id
1621: and cc.code_combination_id = p_code_comb_id;

Line 1717: gl_ledgers led,

1713: AND NVL(ac5,'*') = NVL(p_rec.ac5,'*')
1714: and period_name in (
1715: select per.period_name
1716: from gl_periods per,
1717: gl_ledgers led,
1718: gl_periods ref_per
1719: where per.adjustment_period_flag = 'N'
1720: and led.accounted_period_type = per.period_type
1721: and led.period_set_name = per.period_set_name