1258: where legal_entity_id = cpn_legal_entity_id;
1259:
1260: cursor c_get_ledger_identifier(cpn_ledger_id number) is
1261: select 'LEDGER:' || substr(name, 1, 30) || '-' || ledger_id|| ':'
1262: from gl_ledgers_public_v
1263: where ledger_id = cpn_ledger_id;
1264:
1265: cursor c_get_bsv_identifier(cpv_balancing_segment_value varchar2, cpn_ledger_id number) is
1266: select 'BSV:' || cpv_balancing_segment_value || ':LEDGER:' || substr(name, 1, 30) || '-' || ledger_id|| ':'
1263: where ledger_id = cpn_ledger_id;
1264:
1265: cursor c_get_bsv_identifier(cpv_balancing_segment_value varchar2, cpn_ledger_id number) is
1266: select 'BSV:' || cpv_balancing_segment_value || ':LEDGER:' || substr(name, 1, 30) || '-' || ledger_id|| ':'
1267: from gl_ledgers_public_v
1268: where ledger_id = cpn_ledger_id;
1269:
1270:
1271: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;