APPS.PAY_DB_BALANCES_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 80: insert into pay_balance_dimensions

76:
77: -- do the insert
78:
79: hr_utility.set_location('pay_db_balances_pkg.create_balance_dimension',20);
80: insert into pay_balance_dimensions
81: (balance_dimension_id,
82: business_group_id,
83: legislation_code,
84: route_id,

Line 100: select pay_balance_dimensions_s.nextval,

96: asg_action_balance_dim_id,
97: database_item_function,
98: save_run_balance_enabled,
99: start_date_code)
100: select pay_balance_dimensions_s.nextval,
101: p_business_group_id,
102: p_legislation_code,
103: p_route_id,
104: p_payments_flag,

Line 121: from pay_balance_dimensions

117: p_save_run_balance_enabled,
118: p_start_date_code
119: from dual
120: where not exists (select ''
121: from pay_balance_dimensions
122: where dimension_name = p_dimension_name
123: and nvl(business_group_id, -999) =
124: nvl(p_business_group_id, -999)
125: and nvl(legislation_code, 'NULL') =

Line 131: select pay_balance_dimensions_s.currval

127: );
128: --
129: if (SQL%rowcount > 0) then
130: hr_utility.set_location('pay_db_balances_pkg.create_balance_dimension',30);
131: select pay_balance_dimensions_s.currval
132: into x from dual;
133: return x;
134: else
135: return null;