APPS.CA_GROSSUP_UPD dependencies on PAY_DEFINED_BALANCES

Line 14: from pay_defined_balances

10: --
11: BEGIN
12: select defined_balance_id
13: into l_defbal_id
14: from pay_defined_balances
15: where balance_type_id = p_baltype_id
16: and balance_dimension_id = p_baldim_id
17: and legislation_code = 'CA';
18: --

Line 19: update pay_defined_balances

15: where balance_type_id = p_baltype_id
16: and balance_dimension_id = p_baldim_id
17: and legislation_code = 'CA';
18: --
19: update pay_defined_balances
20: set grossup_allowed_flag = 'Y'
21: where defined_balance_id = l_defbal_id;
22:
23: hr_utility.trace('Updated defined balance id : '||l_defbal_id);

Line 28: insert into pay_defined_balances

24: --
25: EXCEPTION
26: when no_data_found then
27: --
28: insert into pay_defined_balances
29: (defined_balance_id,
30: balance_type_id,
31: balance_dimension_id,
32: legislation_code,

Line 36: values (pay_defined_balances_s.nextval,

32: legislation_code,
33: force_latest_balance_flag,
34: grossup_allowed_flag
35: )
36: values (pay_defined_balances_s.nextval,
37: p_baltype_id,
38: p_baldim_id,
39: 'CA',
40: 'N',

Line 58: pay_defined_balances pdb

54:
55: CURSOR get_latest_bal IS
56: SELECT latest_balance_id
57: FROM pay_assignment_latest_balances alb,
58: pay_defined_balances pdb
59: WHERE alb.latest_balance_id BETWEEN p_start_latest_bal_id
60: AND p_end_latest_bal_id
61: AND alb.defined_balance_id = pdb.defined_balance_id
62: AND pdb.balance_dimension_id = p_dim_id;