APPS.HR_ASSIGNMENT dependencies on PER_TIME_PERIODS

Line 4165: , per_time_periods tp

4161: BEGIN
4162: select tp.end_date
4163: into p_last_standard_date
4164: from per_assignments_f a
4165: , per_time_periods tp
4166: where a.assignment_id = p_assignment_id
4167: and a.effective_end_date = p_start_date - 1
4168: and a.payroll_id = tp.payroll_id
4169: and p_start_date - 1 between tp.start_date and tp.end_date;

Line 4240: , per_time_periods tp

4236: begin
4237: select tp.end_date
4238: into l_new_lspd
4239: from per_assignments_f a
4240: , per_time_periods tp
4241: where a.assignment_id = p_assignment_id
4242: and a.effective_end_date = l_default_lspd
4243: and a.payroll_id = tp.payroll_id
4244: and l_default_lspd between tp.start_date and tp.end_date;

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

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