DBA Data[Home] [Help]

APPS.PAY_CA_WCB_FF_FUNCTIONS dependencies on PAY_WCI_RATES

Line 21: , pay_wci_rates wr

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

Line 59: , pay_wci_rates wr

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

Line 93: from pay_wci_rates

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