APPS.PAY_US_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 = 'US';
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 = 'US';
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: 'US',
40: 'N',

Line 60: SELECT /*+ INDEX(pay_defined_balances PAY_DEFINED_BALANCES_FK2) */

56: --
57: -- Bug 3349650 - Forced index to avoid FTS.
58: --
59: CURSOR get_def_bal IS
60: SELECT /*+ INDEX(pay_defined_balances PAY_DEFINED_BALANCES_FK2) */
61: defined_balance_id
62: FROM pay_defined_balances
63: WHERE balance_dimension_id = p_dim_id;
64:

Line 62: FROM pay_defined_balances

58: --
59: CURSOR get_def_bal IS
60: SELECT /*+ INDEX(pay_defined_balances PAY_DEFINED_BALANCES_FK2) */
61: defined_balance_id
62: FROM pay_defined_balances
63: WHERE balance_dimension_id = p_dim_id;
64:
65: CURSOR get_latest_bal IS
66: SELECT latest_balance_id