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 414: gl_periods fut_periods,

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

Line 473: cp_period_name gl_periods.period_name%TYPE,

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

Line 474: cp_period_year gl_periods.period_year%TYPE

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

Line 478: gl_periods periods,

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

Line 519: gl_periods periods,

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

Line 569: gl_periods fut_periods,

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

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

Line 606: FROM gl_periods periods,

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

Line 611: l_period_num gl_periods.period_num%TYPE;

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;
612:
613:
614: CURSOR c_future_open_periods(
615: cp_application_id xla_ac_balances.application_id%TYPE,

Line 617: cp_period_name gl_periods.period_name%TYPE,

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

Line 618: cp_period_year gl_periods.period_year%TYPE

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

Line 623: gl_periods fut_periods,

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

Line 627: gl_periods ref_period

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
629: AND period_types.period_type = fut_periods.period_type
630: AND fut_period_statuses.ledger_id = ledger.ledger_id
631: AND fut_period_statuses.period_name = fut_periods.period_name

Line 653: cp_period_name gl_periods.period_name%TYPE,

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

Line 654: cp_period_year gl_periods.period_year%TYPE

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

Line 659: gl_periods fut_periods,

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

Line 663: gl_periods ref_period

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
665: AND period_types.period_type = fut_periods.period_type
666: AND fut_period_statuses.ledger_id = ledger.ledger_id
667: AND fut_period_statuses.period_name = fut_periods.period_name

Line 710: gl_periods fut_periods,

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

Line 1724: from gl_periods per,

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

Line 1726: gl_periods ref_per

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