DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PQH_BUDGET_FUND_SRCS

Line 4776: from pqh_budget_fund_srcs src, pqh_budget_elements ele, pqh_budget_sets bset,

4772: sum((decode(unit1,l_money,nvl(bset.budget_unit1_value,0),0)
4773: + decode(unit2,l_money,nvl(bset.budget_unit2_value,0),0)
4774: + decode(unit3,l_money,nvl(bset.budget_unit3_value,0),0))
4775: * (ele.distribution_percentage * src.distribution_percentage/10000)) proportion
4776: from pqh_budget_fund_srcs src, pqh_budget_elements ele, pqh_budget_sets bset,
4777: pqh_budget_periods per, pqh_budget_details det, per_time_periods stp, per_time_periods etp
4778: where
4779: det.position_id = p_position_id and
4780: det.budget_detail_id= per.budget_detail_id