DBA Data[Home] [Help]

APPS.PAY_CA_WCB_FF_FUNCTIONS dependencies on PAY_WCI_RATES

Line 19: , pay_wci_rates wr

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;

Line 56: , pay_wci_rates wr

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

Line 90: from pay_wci_rates

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: --