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_PERIOD_TYPES

Line 414: gl_period_types period_types,

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
418: AND period_types.period_type = fut_periods.period_type

Line 477: gl_period_types period_types,

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
481: AND period_types.period_type = periods.period_type

Line 517: gl_period_types period_types,

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
521: AND period_types.period_type = periods.period_type

Line 566: gl_period_types period_types,

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
570: AND period_types.period_type = fut_periods.period_type

Line 619: gl_period_types period_types,

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

Line 654: gl_period_types period_types,

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

Line 704: gl_period_types period_types,

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
708: AND period_types.period_type = fut_periods.period_type