How to use User Defined Table Value Set in Dependent LOV for Custom ESS Parameter's?

Hello

We have a requirement where they have to create a dependent LOV based on the first LOV selected, using a Table Value set Or SQL queries. 

For Example:- There are 2 parameters in a custom ESS job. 

1. Supplier Name

2. Invoice (AP)

Here the requirement is if a specific 'Supplier' is selected for the 1st parameter, then for

second parameter only 'Invoices' must display that are related to 

Supplier which is passed in 1st Parameter