3448:
3449: BEGIN
3450:
3451: -- Bug 8265487 Added code to delete corresponding data from
3452: -- GL_LEGAL_ENTITIES_BSVS and update GL_LEDGERS
3453: -- accordingly for BAL_SEG_VALUE_OPTION_CODE
3454:
3455: delete from gl_legal_entities_bsvs
3456: where legal_entity_id = x_le_id;
3451: -- Bug 8265487 Added code to delete corresponding data from
3452: -- GL_LEGAL_ENTITIES_BSVS and update GL_LEDGERS
3453: -- accordingly for BAL_SEG_VALUE_OPTION_CODE
3454:
3455: delete from gl_legal_entities_bsvs
3456: where legal_entity_id = x_le_id;
3457:
3458: delete from gl_ledger_norm_seg_vals
3459: where legal_entity_id = x_le_id