DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on PQH_DFLT_BUDGET_ELEMENTS

Line 966: pqh_dflt_budget_elements bel,

962: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit1_value,0)) Amount1,
963: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit2_value,0)) Amount2,
964: SUM((NVL(bfs.dflt_dist_percentage,0)*0.01)*(NVL(bel.dflt_dist_percentage,0)*0.01)*NVL(bst.budget_unit3_value,0)) Amount3
965: FROM pqh_dflt_fund_srcs bfs,
966: pqh_dflt_budget_elements bel,
967: pqh_budget_sets bst,
968: pqh_budget_periods bpr
969: WHERE bpr.budget_period_id = bst.budget_period_id
970: AND bst.dflt_budget_set_id = bel.dflt_budget_set_id