[Home] [Help]
1498: currency VARCHAR2,
1499: start_dt DATE,
1500: end_dt DATE) IS
1501: Select sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
1502: From gl_balances gb
1503: Where gb.code_combination_id = ccid
1504: And gb.ledger_id = sob_id
1505: And gb.currency_code = currency
1506: And gb.actual_flag = 'A'
1520: bud_id NUMBER,
1521: start_dt DATE,
1522: end_dt DATE) IS
1523: Select sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
1524: From gl_balances gb
1525: Where code_combination_id = ccid
1526: And ledger_id = sob_id
1527: And currency_code = currency
1528: And actual_flag = 'B'
1955:
1956: /* --- Bug#3112803 perform input validation in case of ---
1957: --- Populate Recoveries is set to 'YES' ---
1958: --- Only minmum validation is done here to make sure ---
1959: --- that we dont pull in data from GL_BALANCES even if---
1960: --- minimal inputs are not present. The Expense ---
1961: --- Extraction program will do a detailed validation --- */
1962: IF p_populate_rec = 'Y' THEN
1963:
2364: get_ccids(p_sob_id => to_number(p_set_of_books_id),
2365: p_map_t => map_tbl,
2366: p_ccid_t => code_combinations_tbl);
2367:
2368: /* --- get all the Balances from GL Balances --- */
2369:
2370: get_amounts(p_sob_id => to_number(p_set_of_books_id),
2371: p_actual_flag => p_balance_type_code,
2372: p_budget_name => p_budget_name,