DBA Data[Home] [Help]

APPS.PQH_EFC dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 130: pqh_bdgt_pool_realloctions bre

126: SELECT currency_code
127: FROM pqh_budgets bgt,
128: pqh_budget_versions bvr,
129: pqh_budget_pools bpl,
130: pqh_bdgt_pool_realloctions bre
131: WHERE bgt.budget_id = bvr.budget_id
132: AND bvr.budget_version_id = bpl.budget_version_id
133: AND bre.pool_id = bpl.pool_id
134: AND bre.reallocation_id = p_primary_key;

Line 207: -- pqh_bdgt_pool_realloctions BRE

203: FETCH csr_pec INTO l_currency_cd;
204: CLOSE csr_pec;
205: --
206: ELSIF p_entity_cd = 'BRE' THEN
207: -- pqh_bdgt_pool_realloctions BRE
208: OPEN csr_bre;
209: FETCH csr_bre INTO l_currency_cd;
210: CLOSE csr_bre;
211: --

Line 412: FROM pqh_bdgt_pool_realloctions bre,

408: --
409: --
410: CURSOR csr_bre_unit IS
411: SELECT pst1.system_type_cd
412: FROM pqh_bdgt_pool_realloctions bre,
413: pqh_budget_pools bpl,
414: per_shared_types_vl pst1
415: WHERE bre.pool_id = bpl.pool_id
416: AND bpl.budget_unit_id = pst1.shared_type_id