DBA Data[Home] [Help]

APPS.PAY_CA_WCB_FF_FUNCTIONS dependencies on PAY_WCI_ACCOUNTS_V

Line 18: from pay_wci_accounts_v wav

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

Line 55: from pay_wci_accounts_v wav

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