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 415: gl_period_types period_types,

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

Line 479: gl_period_types period_types,

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
482: WHERE ledger.accounted_period_type = period_types.period_type
483: AND period_types.period_type = periods.period_type

Line 520: gl_period_types period_types,

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
523: WHERE ledger.accounted_period_type = period_types.period_type
524: AND period_types.period_type = periods.period_type

Line 570: gl_period_types period_types,

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
573: WHERE ledger.accounted_period_type = period_types.period_type
574: AND period_types.period_type = fut_periods.period_type

Line 624: gl_period_types period_types,

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,
627: gl_periods ref_period
628: WHERE ledger.accounted_period_type = period_types.period_type

Line 660: gl_period_types period_types,

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,
663: gl_periods ref_period
664: WHERE ledger.accounted_period_type = period_types.period_type

Line 711: gl_period_types period_types,

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
714: WHERE ledger.accounted_period_type = period_types.period_type
715: AND period_types.period_type = fut_periods.period_type