APPS.HR_ASSIGNMENT dependencies on PQH_BUDGET_PERIODS

Line 4777: pqh_budget_periods per, pqh_budget_details det, per_time_periods stp, per_time_periods etp

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
4781: and per.budget_period_id = bset.budget_period_id

Line 4811: from pqh_budget_periods per, pqh_budget_details det,

4807: select
4808: decode(unit1,l_money,nvl(per.budget_unit1_value,0),0)+
4809: decode(unit2,l_money,nvl(per.budget_unit2_value,0),0)+
4810: decode(unit3,l_money,nvl(per.budget_unit3_value,0),0) period_value
4811: from pqh_budget_periods per, pqh_budget_details det,
4812: per_time_periods stp, per_time_periods etp
4813: where
4814: det.position_id = p_position_id and
4815: det.budget_detail_id= per.budget_detail_id