DBA Data[Home] [Help]

APPS.PQH_BFS_BUS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 233: from pay_cost_allocation_keyflex a

229: l_dummy varchar2(1);
230: --
231: cursor c1 is
232: select null
233: from pay_cost_allocation_keyflex a
234: where a.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
235: --
236: Begin
237: --

Line 249: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table

245: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
247: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
248: --
249: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table
250: --
251: open c1;
252: --
253: fetch c1 into l_dummy;