DBA Data[Home] [Help]

APPS.PAY_CA_WCB_FF_FUNCTIONS dependencies on PAY_WCI_ACCOUNTS_V

Line 20: from pay_wci_accounts_v wav

16: ,p_code varchar2
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

Line 58: from pay_wci_accounts_v wav

54: ,p_job varchar2
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