End Dating a BSA
I have a request to end date/terminate a Blanket Sales Agreement whenever there is a customer attached to it who is inactive. So, if I inactivate a customer how could i end date all of the customer's BSA's?? A Pl/sql function, or possibly a database trigger? Anyone have any good suggestions? Thanks in advance.
Chris