DBA Data[Home] [Help]

APPS.PAY_DB_BALANCES_PKG dependencies on DUAL

Line 119: from dual

115: p_asg_bal_dim,
116: p_dbi_function,
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) =

Line 132: into x from dual;

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;
136: end if;

Line 179: from sys.dual

175: p_run_dim_id,
176: p_priority,
177: p_baltyp_col,
178: p_dec_required
179: from sys.dual
180: where not exists (select ''
181: from pay_dimension_routes
182: where balance_dimension_id = p_dim_id
183: and route_type = p_route_type