APPS.HR_ASSIGNMENT dependencies on PER_TIME_PERIODS

Line 4205: , per_time_periods tp

4201: BEGIN
4202: select tp.end_date
4203: into p_last_standard_date
4204: from per_assignments_f a
4205: , per_time_periods tp
4206: where a.assignment_id = p_assignment_id
4207: and a.effective_end_date = p_start_date - 1
4208: and a.payroll_id = tp.payroll_id
4209: and p_start_date - 1 between tp.start_date and tp.end_date;

Line 4280: , per_time_periods tp

4276: begin
4277: select tp.end_date
4278: into l_new_lspd
4279: from per_assignments_f a
4280: , per_time_periods tp
4281: where a.assignment_id = p_assignment_id
4282: and a.effective_end_date = l_default_lspd
4283: and a.payroll_id = tp.payroll_id
4284: and l_default_lspd between tp.start_date and tp.end_date;

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 4852: per_time_periods stp, per_time_periods etp

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
4856: and per.start_time_period_id = stp.time_period_id