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
23: and wr.code = p_code;
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
60: and wr.rate_id = wo.rate_id
86: --
87: CURSOR get_wcb_rate(p_rate_id number) IS
88: --
89: select nvl(rate,0)
90: from pay_wci_rates
91: where rate_id = p_rate_id;
92: --
93: BEGIN
94: --