[Home] [Help]
1168: from per_all_assignments_f a,
1169: per_all_people_f p,
1170: per_contracts_f c,
1171: per_person_type_usages_f ptu,
1172: per_assignment_budget_values_f b
1173: where a.assignment_id = p_assignment_id
1174: and p.person_id = a.person_id
1175: and c.contract_id(+) = a.contract_id
1176: and ptu.person_id = p.person_id
1275: hr_soft_coding_keyflex scl,
1276: per_all_positions pos,
1277: hr_organization_information org,
1278: hr_organization_information bus,
1279: per_assignment_budget_values_f bud,
1280: per_all_assignments_f asg
1281: where asg.assignment_id = p_assignment_id
1282: and p_start_date between asg.effective_start_date
1283: and asg.effective_end_date