DBA Data[Home] [Help]

APPS.PQH_BRE_BUS dependencies on PER_BUSINESS_GROUPS

Line 31: from per_business_groups pbg

27: -- Declare cursor
28: --
29: cursor csr_trnx_dtl_sec_grp is
30: select pbg.security_group_id
31: from per_business_groups pbg
32: , pqh_budget_pools bpl
33: where bpl.pool_id = p_pool_id
34: and pbg.business_group_id = bpl.business_group_id;
35:

Line 38: from per_business_groups pbg

34: and pbg.business_group_id = bpl.business_group_id;
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

Line 142: from per_business_groups pbg

138: -- Declare cursor
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')