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_PERIODS

Line 413: gl_periods fut_periods,

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
417: WHERE ledger.accounted_period_type = period_types.period_type

Line 471: cp_period_name gl_periods.period_name%TYPE,

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
474: SELECT periods.end_date
475: FROM gl_ledgers ledger,

Line 472: cp_period_year gl_periods.period_year%TYPE

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
474: SELECT periods.end_date
475: FROM gl_ledgers ledger,
476: gl_periods periods,

Line 476: gl_periods periods,

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
480: WHERE ledger.accounted_period_type = period_types.period_type

Line 516: gl_periods periods,

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
520: WHERE ledger.accounted_period_type = period_types.period_type

Line 565: gl_periods fut_periods,

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
569: WHERE ledger.accounted_period_type = period_types.period_type

Line 598: cp_period_name gl_periods.period_name%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,
602: gl_ledgers ledger

Line 601: FROM gl_periods periods,

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,
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;

Line 606: l_period_num gl_periods.period_num%TYPE;

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;
607:
608:
609: CURSOR c_future_open_periods(
610: cp_application_id xla_ac_balances.application_id%TYPE,

Line 612: cp_period_name gl_periods.period_name%TYPE,

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,
616: fut_periods.period_num

Line 613: cp_period_year gl_periods.period_year%TYPE

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,
616: fut_periods.period_num
617: FROM gl_ledgers ledger,

Line 618: gl_periods fut_periods,

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,
622: gl_periods ref_period

Line 622: gl_periods ref_period

618: gl_periods fut_periods,
619: gl_period_types period_types,
620: gl_period_statuses fut_period_statuses,
621: gl_period_sets period_sets,
622: gl_periods ref_period
623: WHERE ledger.accounted_period_type = period_types.period_type
624: AND period_types.period_type = fut_periods.period_type
625: AND fut_period_statuses.ledger_id = ledger.ledger_id
626: AND fut_period_statuses.period_name = fut_periods.period_name

Line 647: cp_period_name gl_periods.period_name%TYPE,

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,
651: fut_periods.period_num

Line 648: cp_period_year gl_periods.period_year%TYPE

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,
651: fut_periods.period_num
652: FROM gl_ledgers ledger,

Line 653: gl_periods fut_periods,

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,
657: gl_periods ref_period

Line 657: gl_periods ref_period

653: gl_periods fut_periods,
654: gl_period_types period_types,
655: gl_period_statuses fut_period_statuses,
656: gl_period_sets period_sets,
657: gl_periods ref_period
658: WHERE ledger.accounted_period_type = period_types.period_type
659: AND period_types.period_type = fut_periods.period_type
660: AND fut_period_statuses.ledger_id = ledger.ledger_id
661: AND fut_period_statuses.period_name = fut_periods.period_name

Line 703: gl_periods fut_periods,

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
707: WHERE ledger.accounted_period_type = period_types.period_type

Line 1716: from gl_periods per,

1712: AND NVL(ac4,'*') = NVL(p_rec.ac4,'*')
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

Line 1718: gl_periods ref_per

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
1722: and led.ledger_id = p_rec.ledger_id