188:
189: CURSOR c_templacct
190: IS
191: SELECT code_combination_id
192: FROM psb_fund_balance_accounts
193: WHERE set_of_books_id = g_set_of_books_id
194: AND template_account = 'Y';
195:
196: CURSOR c_nontemplacct
196: CURSOR c_nontemplacct
197: IS
198: SELECT a.code_combination_id
199: FROM gl_code_combinations a,
200: psb_fund_balance_accounts b
201: WHERE a.code_combination_id = b.code_combination_id
202: AND b.set_of_books_id = g_set_of_books_id
203: AND DECODE(g_fund_segment,'SEGMENT1', SEGMENT1,
204: 'SEGMENT2', SEGMENT2,