DBA Data[Home] [Help]

APPS.PQH_EFC dependencies on PQH_BUDGET_POOLS

Line 129: pqh_budget_pools bpl,

125: CURSOR csr_bre IS
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

Line 413: pqh_budget_pools bpl,

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
417: AND bre.reallocation_id = p_primary_key;