17: ,p_jurisdiction varchar2) IS
18: --
19: select wr.rate_id
20: from pay_wci_accounts_v wav
21: , pay_wci_rates wr
22: where wav.account_id = wr.account_id
23: and wav.province = p_jurisdiction
24: and wav.account_number = p_account_number
25: and wr.code = p_code
55: ,p_jurisdiction varchar2) IS
56: --
57: select wr.rate_id
58: from pay_wci_accounts_v wav
59: , pay_wci_rates wr
60: , pay_wci_occupations wo
61: , per_jobs pj
62: where wav.account_id = wr.account_id
63: and wr.rate_id = wo.rate_id
89: --
90: CURSOR get_wcb_rate(p_rate_id number) IS
91: --
92: select nvl(rate,0)
93: from pay_wci_rates
94: where rate_id = p_rate_id;
95: --
96: BEGIN
97: --