DBA Data[Home] [Help]

APPS.GL_BUDGET_TRANSFER_PKG dependencies on GL_BALANCES

Line 144: -- Get the from and to balances from gl_balances

140:
141: temp_bal NUMBER;
142: BEGIN
143:
144: -- Get the from and to balances from gl_balances
145: OPEN get_balance;
146: FETCH get_balance INTO temp_bal;
147: IF (get_balance%NOTFOUND) THEN
148: CLOSE get_balance;

Line 170: FROM gl_balances bal

166: SELECT nvl(period_net_dr,0) - nvl(period_net_cr,0) PERIOD_NET,
167: nvl(begin_balance_dr,0) - nvl(begin_balance_cr,0) BEGIN_BAL,
168: nvl(quarter_to_date_dr,0)-nvl(quarter_to_date_cr,0) QUARTER_BAL,
169: nvl(project_to_date_dr,0)-nvl(project_to_date_cr,0) PROJECT_BAL
170: FROM gl_balances bal
171: WHERE bal.ledger_id = xledger_id
172: AND bal.period_name = xperiod_name
173: AND bal.code_combination_id = xcode_combination_id
174: AND bal.actual_flag = xactual_flag

Line 187: -- Get the from and to balances from gl_balances

183: quarter_bal NUMBER;
184: project_bal NUMBER;
185: BEGIN
186:
187: -- Get the from and to balances from gl_balances
188: OPEN get_balance;
189: FETCH get_balance INTO period_net, begin_bal, quarter_bal, project_bal;
190: IF (get_balance%NOTFOUND) THEN
191: CLOSE get_balance;