14: ,p_code varchar2
15: ,p_jurisdiction varchar2) IS
16: --
17: select wr.rate_id
18: from pay_wci_accounts_v wav
19: , pay_wci_rates wr
20: where wav.account_id = wr.account_id
21: and wav.province = p_jurisdiction
22: and wav.account_number = p_account_number
51: ,p_job varchar2
52: ,p_jurisdiction varchar2) IS
53: --
54: select wr.rate_id
55: from pay_wci_accounts_v wav
56: , pay_wci_rates wr
57: , pay_wci_occupations wo
58: , per_jobs pj
59: where wav.account_id = wr.account_id