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.CE_BANK_ACCT_BALANCE_REPORT dependencies on DUAL

Line 607: from dual;

603:
604: -- set the v_LegerBalanceRC
605: select decode(v_exchange_rate, -1, v_dummy, v_LegerBalanceAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')),p_exchange_rate_type))
606: into v_LegerBalanceRC
607: from dual;
608:
609: -- get v_AvailableBalanceAC from the nearest date
610: if v_AvailableBalanceAC is null then
611: get_balance_near_date(v_bank_account_id, l_date, v_AvailableBalanceAC, v_AvailableBalance_Date, 'AvailableBalance');

Line 619: from dual;

615:
616: -- set the v_AvailableBalanceRC
617: select decode(v_exchange_rate, -1, v_dummy, v_AvailableBalanceAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')) ,p_exchange_rate_type))
618: into v_AvailableBalanceRC
619: from dual;
620:
621: -- get v_IntCalBalanceAC from the nearest date
622: if v_IntCalBalanceAC is null then
623: get_balance_near_date(v_bank_account_id, l_date, v_IntCalBalanceAC, v_IntCalBalance_Date, 'IntCalBalance');

Line 629: from dual;

625:
626: -- set the v_IntCalBalanceRC
627: select decode(v_exchange_rate, -1, v_dummy, v_IntCalBalanceAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')),p_exchange_rate_type))
628: into v_IntCalBalanceRC
629: from dual;
630:
631: -- get v_OneDayFloatAC from the nearest date
632: if v_OneDayFloatAC is null then
633: get_balance_near_date(v_bank_account_id, l_date, v_OneDayFloatAC, v_OneDayFloat_Date, 'OneDayFloat');

Line 639: from dual;

635:
636: -- set the v_OneDayFloatRC
637: select decode(v_exchange_rate, -1, v_dummy, v_OneDayFloatAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date,to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')) ,p_exchange_rate_type))
638: into v_OneDayFloatRC
639: from dual;
640:
641: -- get v_TwoDayFloatAC from the nearest date
642: if v_TwoDayFloatAC is null then
643: get_balance_near_date(v_bank_account_id, l_date, v_TwoDayFloatAC, v_TwoDayFloat_Date, 'TwoDayFloat');

Line 649: from dual;

645:
646: -- set the v_TwoDayFloatRC
647: select decode(v_exchange_rate, -1, v_dummy, v_TwoDayFloatAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')), p_exchange_rate_type))
648: into v_TwoDayFloatRC
649: from dual;
650:
651: -- get v_AvgLegerMTDAC from the nearest date
652: if v_AvgLegerMTDAC is null then
653: get_balance_near_date(v_bank_account_id, l_date, v_AvgLegerMTDAC, v_AvgLegerMTD_Date, 'AvgLegerMTD');

Line 659: from dual;

655:
656: -- set the v_AvgLegerMTDRC
657: select decode(v_exchange_rate, -1, v_dummy, v_AvgLegerMTDAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date,to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')), p_exchange_rate_type))
658: into v_AvgLegerMTDRC
659: from dual;
660:
661: -- get v_AvgLegerYTDAC from the nearest date
662: if v_AvgLegerYTDAC is null then
663: get_balance_near_date(v_bank_account_id, l_date, v_AvgLegerYTDAC, v_AvgLegerYTD_Date, 'AvgLegerYTD');

Line 669: from dual;

665:
666: -- set the v_AvgLegerYTDRC
667: select decode(v_exchange_rate, -1, v_dummy, v_AvgLegerYTDAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')), p_exchange_rate_type))
668: into v_AvgLegerYTDRC
669: from dual;
670:
671: -- get v_AvgAvailableMTDAC from the nearest date
672: if v_AvgAvailableMTDAC is null then
673: get_balance_near_date(v_bank_account_id, l_date, v_AvgAvailableMTDAC, v_AvgAvailableMTD_Date, 'AvgAvailableMTD');

Line 679: from dual;

675:
676: -- set the v_AvgAvailableMTDRC
677: select decode(v_exchange_rate, -1, v_dummy, v_AvgAvailableMTDAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')), p_exchange_rate_type))
678: into v_AvgAvailableMTDRC
679: from dual;
680:
681: -- get v_AvgAvailableYTDAC from the nearest date
682: if v_AvgAvailableYTDAC is null then
683: get_balance_near_date(v_bank_account_id, l_date, v_AvgAvailableYTDAC, v_AvgAvailableYTD_Date, 'AvgAvailableYTD');

Line 689: from dual;

685:
686: -- set the v_AvgAvailableYTDRC
687: select decode(v_exchange_rate, -1, v_dummy, v_AvgAvailableYTDAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date,to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')), p_exchange_rate_type))
688: into v_AvgAvailableYTDRC
689: from dual;
690:
691: -- set the subtotal values
692:
693: -- ledgeBalance Sub Total

Line 925: from dual;

921:
922: -- concat all xml nodes
923: select xmlconcat(v_xml_seg1, v_xml_seg2)
924: into v_xml_seg3
925: from dual;
926:
927: v_xml_seg2 := v_xml_seg3;
928: end loop;
929: close cursor_bank_account_id;

Line 955: from dual;

951: CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDSubTRC, p_reporting_currency) as "SubTotalAvgAvailableYTDRC"
952: )
953: )
954: into v_xml_1
955: from dual;
956:
957: -- concat all xml nodes
958: select xmlconcat(v_xml_1, v_xml_2)
959: into v_xml_3

Line 960: from dual;

956:
957: -- concat all xml nodes
958: select xmlconcat(v_xml_1, v_xml_2)
959: into v_xml_3
960: from dual;
961:
962: v_xml_2 := v_xml_3;
963: end if;
964: end loop;

Line 992: from dual;

988: xmlelement("AvgAvailableMTDTotal", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableMTDTotal, p_reporting_currency)),
989: xmlelement("AvgAvailableYTDTotal", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDTotal, p_reporting_currency))
990: )
991: into l_xml
992: from dual;
993:
994: l_xml_doc := l_xml.getClobVal();
995:
996: CE_BANKACCT_BA_REPORT_UTIL.printClobOut(l_xml_doc);