APPS.PQH_BRE_BUS dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 39: , pqh_bdgt_pool_realloctions bre

35:
36: cursor csr_trnx_amt_sec_grp is
37: select pbg.security_group_id
38: from per_business_groups pbg
39: , pqh_bdgt_pool_realloctions bre
40: , pqh_budget_pools bpl
41: where bre.reallocation_id = p_txn_detail_id
42: and bre.pool_id = bpl.pool_id
43: and pbg.business_group_id = bpl.business_group_id;

Line 143: , pqh_bdgt_pool_realloctions bre

139: --
140: cursor csr_leg_code is
141: select pbg.legislation_code
142: from per_business_groups pbg
143: , pqh_bdgt_pool_realloctions bre
144: , pqh_budget_pools bpl
145: where bre.reallocation_id = p_reallocation_id
146: and ( (bre.transaction_type in ('D','R')
147: and bre.pool_id = bpl.pool_id)

Line 150: from pqh_bdgt_pool_realloctions

146: and ( (bre.transaction_type in ('D','R')
147: and bre.pool_id = bpl.pool_id)
148: OR (bre.transaction_type in ('DD','RD')
149: and bpl.pool_id = (select txn_detail_id
150: from pqh_bdgt_pool_realloctions
151: where reallocation_id = p_reallocation_id)) )
152: and pbg.business_group_id = bpl.business_group_id;
153: --
154: -- Declare local variables

Line 310: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');

306: <> pqh_bre_shd.g_old_rec.reallocation_id) then
307: --
308: -- raise error as PK has changed
309: --
310: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');
311: --
312: elsif not l_api_updating then
313: --
314: -- check if PK is null

Line 320: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');

316: if p_reallocation_id is not null then
317: --
318: -- raise error as PK is not null
319: --
320: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS');
321: --
322: end if;
323: --
324: end if;

Line 372: from pqh_bdgt_pool_realloctions a

368: where a.pool_id = p_pool_id;
369: --
370: cursor c2 is
371: select null
372: from pqh_bdgt_pool_realloctions a
373: where a.reallocation_id = p_txn_detail_id;
374: Begin
375: --
376: hr_utility.set_location('Entering:'||l_proc,5);

Line 401: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');

397: --
398: -- raise error as FK does not relate to PK in pqh_budget_pools
399: -- table.
400: --
401: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');
402: --
403: end if;
404: --
405: close c1;

Line 423: -- check if txn_detail_id value exists in pqh_bdgt_pool_realloctions table

419: and nvl(p_txn_detail_id,hr_api.g_number)
420: <> nvl(pqh_bre_shd.g_old_rec.txn_detail_id,hr_api.g_number)
421: or not l_api_updating) then
422: --
423: -- check if txn_detail_id value exists in pqh_bdgt_pool_realloctions table
424: --
425: open c2;
426: --
427: fetch c2 into l_dummy;

Line 432: -- raise error as FK does not relate to PK in pqh_bdgt_pool_realloctions

428: if c2%notfound then
429: --
430: close c2;
431: --
432: -- raise error as FK does not relate to PK in pqh_bdgt_pool_realloctions
433: -- table.
434: --
435: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');
436: --

Line 435: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');

431: --
432: -- raise error as FK does not relate to PK in pqh_bdgt_pool_realloctions
433: -- table.
434: --
435: pqh_bre_shd.constraint_error('PQH_BDGT_POOL_REALLOCTIONS_FK1');
436: --
437: end if;
438: --
439: close c2;