163: period_mon,
164: account_type,
165: PERIOD_NAME
166: @COLUMN_CLAUSE
167: FROM ja_cn_account_balances_v
168: WHERE period_name = :2
169: AND account_segment = :3
170: AND ledger_id = :4
171: AND company_segment IN
222: OR dff_title_code = 'ACLE');
223:
224: CURSOR c_in_ja_cn_account_balances IS
225: SELECT DISTINCT account_segment
226: FROM ja_cn_account_balances_v
227: WHERE company_segment IN
228: (SELECT bal_seg_value--segment_value
229: FROM ja_cn_ledger_le_bsv_gt--ja_cn_legal_companies_all
230: WHERE legal_entity_id = p_legal_entity