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 413: gl_ledgers ledger,

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

Line 471: cp_ledger_id gl_ledgers.ledger_id%TYPE,

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

Line 477: FROM gl_ledgers ledger,

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

Line 518: gl_ledgers ledger,

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

Line 568: FROM gl_ledgers ledger,

564: ) IS
565: SELECT fut_periods.period_name,
566: fut_periods.period_year,
567: fut_periods.period_num
568: FROM gl_ledgers ledger,
569: gl_periods fut_periods,
570: gl_period_types period_types,
571: gl_period_statuses fut_period_statuses,
572: gl_period_sets period_sets

Line 602: cp_application_id gl_ledgers.ledger_id%TYPE,

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,
603: cp_period_name gl_periods.period_name%TYPE
604: ) IS
605: SELECT periods.period_num
606: FROM gl_periods periods,

Line 607: gl_ledgers ledger

603: cp_period_name gl_periods.period_name%TYPE
604: ) IS
605: SELECT periods.period_num
606: FROM gl_periods periods,
607: gl_ledgers ledger
608: WHERE ledger.ledger_id = cp_application_id
609: AND ledger.period_set_name = periods.period_set_name
610: AND periods.period_name = cp_period_name;
611: l_period_num gl_periods.period_num%TYPE;

Line 616: cp_ledger_id gl_ledgers.ledger_id%TYPE,

612:
613:
614: CURSOR c_future_open_periods(
615: cp_application_id xla_ac_balances.application_id%TYPE,
616: cp_ledger_id gl_ledgers.ledger_id%TYPE,
617: cp_period_name gl_periods.period_name%TYPE,
618: cp_period_year gl_periods.period_year%TYPE
619: ) IS
620: SELECT fut_periods.period_name,

Line 622: FROM gl_ledgers ledger,

618: cp_period_year gl_periods.period_year%TYPE
619: ) IS
620: SELECT fut_periods.period_name,
621: fut_periods.period_num
622: FROM gl_ledgers ledger,
623: gl_periods fut_periods,
624: gl_period_types period_types,
625: gl_period_statuses fut_period_statuses,
626: gl_period_sets period_sets,

Line 652: cp_ledger_id gl_ledgers.ledger_id%TYPE,

648: l_future_open_periods c_future_open_periods%ROWTYPE;
649:
650: CURSOR c_closed_periods(
651: cp_application_id xla_ac_balances.application_id%TYPE,
652: cp_ledger_id gl_ledgers.ledger_id%TYPE,
653: cp_period_name gl_periods.period_name%TYPE,
654: cp_period_year gl_periods.period_year%TYPE
655: ) IS
656: SELECT fut_periods.period_name,

Line 658: FROM gl_ledgers ledger,

654: cp_period_year gl_periods.period_year%TYPE
655: ) IS
656: SELECT fut_periods.period_name,
657: fut_periods.period_num
658: FROM gl_ledgers ledger,
659: gl_periods fut_periods,
660: gl_period_types period_types,
661: gl_period_statuses fut_period_statuses,
662: gl_period_sets period_sets,

Line 709: gl_ledgers ledger,

705: cp_period_year xla_ac_balances.period_year%TYPE
706: ) IS
707: SELECT xab.*
708: FROM xla_ac_balances xab,
709: gl_ledgers ledger,
710: gl_periods fut_periods,
711: gl_period_types period_types,
712: gl_period_statuses fut_period_statuses,
713: gl_period_sets period_sets

Line 1565: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;

1561: l_result boolean :=true;
1562: l_rec xla_ac_balances_int%ROWTYPE := p_balances_int_rec;
1563: l_test_value NUMBER;
1564: l_error_codes xla_ac_balances_int.message_codes%TYPE;
1565: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
1566: l_code_comb_id xla_ac_balances_int.code_combination_id%TYPE;
1567: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
1568:
1569: x_err_msg VARCHAR2(1000);

Line 1567: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;

1563: l_test_value NUMBER;
1564: l_error_codes xla_ac_balances_int.message_codes%TYPE;
1565: l_ledger_category_code gl_ledgers.ledger_category_code%TYPE;
1566: l_code_comb_id xla_ac_balances_int.code_combination_id%TYPE;
1567: l_coa_id gl_ledgers.chart_of_accounts_id%TYPE;
1568:
1569: x_err_msg VARCHAR2(1000);
1570: x_ccid NUMBER := 0;
1571: x_templgrid NUMBER := 0;

Line 1592: from gl_ledgers

1588: --
1589: --=============================================================================
1590: CURSOR c_is_valid_ledger(p_ledger_id xla_ac_balances_int.ledger_id%TYPE) IS
1591: select ledger_category_code
1592: from gl_ledgers
1593: where ledger_id = p_ledger_id;
1594:
1595: --=============================================================================
1596: --

Line 1613: from gl_ledgers

1609: --
1610: --=============================================================================
1611: CURSOR c_fetch_coa_id(p_ledger_id xla_ac_balances_int.ledger_id%TYPE) IS
1612: select chart_of_accounts_id
1613: from gl_ledgers
1614: where ledger_id = p_ledger_id;
1615:
1616: --=============================================================================
1617: --

Line 1625: from gl_ledgers lg,

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

Line 1725: gl_ledgers led,

1721: AND NVL(ac5,'*') = NVL(p_rec.ac5,'*')
1722: and period_name in (
1723: select per.period_name
1724: from gl_periods per,
1725: gl_ledgers led,
1726: gl_periods ref_per
1727: where per.adjustment_period_flag = 'N'
1728: and led.accounted_period_type = per.period_type
1729: and led.period_set_name = per.period_set_name