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 577: from dual;

573:
574: -- set the v_LegerBalanceRC
575: 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))
576: into v_LegerBalanceRC
577: from dual;
578:
579: -- get v_AvailableBalanceAC from the nearest date
580: if v_AvailableBalanceAC is null then
581: get_balance_near_date(v_bank_account_id, l_date, v_AvailableBalanceAC, v_AvailableBalance_Date, 'AvailableBalance');

Line 589: from dual;

585:
586: -- set the v_AvailableBalanceRC
587: 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))
588: into v_AvailableBalanceRC
589: from dual;
590:
591: -- get v_IntCalBalanceAC from the nearest date
592: if v_IntCalBalanceAC is null then
593: get_balance_near_date(v_bank_account_id, l_date, v_IntCalBalanceAC, v_IntCalBalance_Date, 'IntCalBalance');

Line 599: from dual;

595:
596: -- set the v_IntCalBalanceRC
597: 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))
598: into v_IntCalBalanceRC
599: from dual;
600:
601: -- get v_OneDayFloatAC from the nearest date
602: if v_OneDayFloatAC is null then
603: get_balance_near_date(v_bank_account_id, l_date, v_OneDayFloatAC, v_OneDayFloat_Date, 'OneDayFloat');

Line 609: from dual;

605:
606: -- set the v_OneDayFloatRC
607: 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))
608: into v_OneDayFloatRC
609: from dual;
610:
611: -- get v_TwoDayFloatAC from the nearest date
612: if v_TwoDayFloatAC is null then
613: get_balance_near_date(v_bank_account_id, l_date, v_TwoDayFloatAC, v_TwoDayFloat_Date, 'TwoDayFloat');

Line 619: from dual;

615:
616: -- set the v_TwoDayFloatRC
617: 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))
618: into v_TwoDayFloatRC
619: from dual;
620:
621: -- get v_AvgLegerMTDAC from the nearest date
622: if v_AvgLegerMTDAC is null then
623: get_balance_near_date(v_bank_account_id, l_date, v_AvgLegerMTDAC, v_AvgLegerMTD_Date, 'AvgLegerMTD');

Line 629: from dual;

625:
626: -- set the v_AvgLegerMTDRC
627: 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))
628: into v_AvgLegerMTDRC
629: from dual;
630:
631: -- get v_AvgLegerYTDAC from the nearest date
632: if v_AvgLegerYTDAC is null then
633: get_balance_near_date(v_bank_account_id, l_date, v_AvgLegerYTDAC, v_AvgLegerYTD_Date, 'AvgLegerYTD');

Line 639: from dual;

635:
636: -- set the v_AvgLegerYTDRC
637: 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))
638: into v_AvgLegerYTDRC
639: from dual;
640:
641: -- get v_AvgAvailableMTDAC from the nearest date
642: if v_AvgAvailableMTDAC is null then
643: get_balance_near_date(v_bank_account_id, l_date, v_AvgAvailableMTDAC, v_AvgAvailableMTD_Date, 'AvgAvailableMTD');

Line 649: from dual;

645:
646: -- set the v_AvgAvailableMTDRC
647: 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))
648: into v_AvgAvailableMTDRC
649: from dual;
650:
651: -- get v_AvgAvailableYTDAC from the nearest date
652: if v_AvgAvailableYTDAC is null then
653: get_balance_near_date(v_bank_account_id, l_date, v_AvgAvailableYTDAC, v_AvgAvailableYTD_Date, 'AvgAvailableYTD');

Line 659: from dual;

655:
656: -- set the v_AvgAvailableYTDRC
657: 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))
658: into v_AvgAvailableYTDRC
659: from dual;
660:
661: -- set the subtotal values
662:
663: -- ledgeBalance Sub Total

Line 895: from dual;

891:
892: -- concat all xml nodes
893: select xmlconcat(v_xml_seg1, v_xml_seg2)
894: into v_xml_seg3
895: from dual;
896:
897: v_xml_seg2 := v_xml_seg3;
898: end loop;
899: close cursor_bank_account_id;

Line 925: from dual;

921: CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDSubTRC, p_reporting_currency) as "SubTotalAvgAvailableYTDRC"
922: )
923: )
924: into v_xml_1
925: from dual;
926:
927: -- concat all xml nodes
928: select xmlconcat(v_xml_1, v_xml_2)
929: into v_xml_3

Line 930: from dual;

926:
927: -- concat all xml nodes
928: select xmlconcat(v_xml_1, v_xml_2)
929: into v_xml_3
930: from dual;
931:
932: v_xml_2 := v_xml_3;
933: end loop;
934: close cursor_bank_currency_code;

Line 961: from dual;

957: xmlelement("AvgAvailableMTDTotal", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableMTDTotal, p_reporting_currency)),
958: xmlelement("AvgAvailableYTDTotal", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDTotal, p_reporting_currency))
959: )
960: into l_xml
961: from dual;
962:
963: l_xml_doc := l_xml.getClobVal();
964:
965: CE_BANKACCT_BA_REPORT_UTIL.printClobOut(l_xml_doc);