APPS.HR_ASSIGNMENT dependencies on PQH_BUDGET_DETAILS

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

4813: + decode(unit2,l_money,nvl(bset.budget_unit2_value,0),0)
4814: + decode(unit3,l_money,nvl(bset.budget_unit3_value,0),0))
4815: * (ele.distribution_percentage * src.distribution_percentage/10000)) proportion
4816: from pqh_budget_fund_srcs src, pqh_budget_elements ele, pqh_budget_sets bset,
4817: pqh_budget_periods per, pqh_budget_details det, per_time_periods stp, per_time_periods etp
4818: where
4819: det.position_id = p_position_id and
4820: det.budget_detail_id= per.budget_detail_id
4821: and per.budget_period_id = bset.budget_period_id

Line 4851: from pqh_budget_periods per, pqh_budget_details det,

4847: select
4848: decode(unit1,l_money,nvl(per.budget_unit1_value,0),0)+
4849: decode(unit2,l_money,nvl(per.budget_unit2_value,0),0)+
4850: decode(unit3,l_money,nvl(per.budget_unit3_value,0),0) period_value
4851: from pqh_budget_periods per, pqh_budget_details det,
4852: per_time_periods stp, per_time_periods etp
4853: where
4854: det.position_id = p_position_id and
4855: det.budget_detail_id= per.budget_detail_id