[Home] [Help]
35: | 23-Dec-2010 nksurana Added new variables to move the logic from |
36: | xml to pkb to make the xml reuasable and |
37: | improve performance. |
38: | 16-Aug-2011 nksurana Added additional filter in the insert into |
39: | xla_report_balances_gt when the flag |
40: | P_INCLUDE_ACCT_WITH_NO_ACT is NULL or N. |
41: +===========================================================================*/
42:
43: --=============================================================================
1464: ,gl_import_references gir
1465: ,gl_je_lines gjl
1466: ,gl_je_headers gjh
1467: ,gl_je_batches gjb
1468: ,xla_report_balances_gt glbgt';
1469:
1470: p_sla_main_filter:=
1471: 'AND gjl.ledger_id = glbgt.ledger_id
1472: AND gjl.code_combination_id = glbgt.code_combination_id
1617: ,gl_daily_conversion_types gdct
1618: ,gl_je_lines gjl
1619: ,gl_je_headers gjh
1620: ,gl_je_batches gjb
1621: ,xla_report_balances_gt glbgt';
1622:
1623: p_gl_main_filter:=
1624: 'WHERE gjl.ledger_id = glbgt.ledger_id
1625: AND gjl.code_combination_id = glbgt.code_combination_id
1868: ,glbgt.le_br_daily_location LE_BR_DAILY_LOCATION
1869: ,glbgt.le_br_director_number LE_BR_DIRECTOR_NUMBER
1870: ,glbgt.le_br_accountant_number LE_BR_ACCOUNTANT_NUMBER
1871: ,glbgt.le_br_accountant_name LE_BR_ACCOUNTANT_NAME
1872: FROM xla_report_balances_gt glbgt
1873: WHERE nvl(period_net_dr,0) = 0
1874: AND nvl(period_net_cr,0) = 0
1875: AND (nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0) ) <> 0';
1876:
1913:
1914:
1915: l_balance_query :=
1916: '
1917: INSERT INTO xla_report_balances_gt
1918: (ledger_id
1919: ,ledger_short_name
1920: ,ledger_description
1921: ,ledger_name
2198: ,l_end_period_num
2199: ,p_ledger_id;
2200:
2201: IF ((p_gl_date_from > l_start_date) OR (p_gl_date_to < l_end_date)) THEN
2202: UPDATE xla_report_balances_gt xrb
2203: SET (begin_running_total_cr
2204: ,begin_running_Total_dr
2205: ,end_running_total_cr
2206: ,end_running_total_dr) =