[Home] [Help]
155: 'select distinct paf.person_id person_id ,pef.employee_number employee_number,pef.full_name full_name
156: from per_all_assignments_f paf,
157: hr_assignment_sets hs,
158: per_all_people_f pef,
159: per_periods_of_service ppos
160: where hs.assignment_set_id=:p_assignment_set_id
161: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
162: and hs.business_group_id=paf.business_group_id
163: and pef.person_id=paf.person_id
193: 'select distinct paf.person_id person_id ,pef.employee_number employee_number,pef.full_name full_name
194: from per_all_assignments_f paf,
195: hr_assignment_sets hs,
196: per_all_people_f pef,
197: per_periods_of_service ppos
198: where hs.assignment_set_id=:p_assignment_set_id
199: and hs.business_group_id=paf.business_group_id
200: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
201: and pef.person_id=paf.person_id
230: 'select distinct paf.person_id ,pef.employee_number employee_number,pef.full_name full_name
231: from per_all_assignments_f paf,
232: hr_assignment_sets hs,
233: per_all_people_f pef,
234: per_periods_of_service ppos
235: where hs.assignment_set_id=:p_assignment_set_id
236: and hs.business_group_id=paf.business_group_id
237: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
238: and pef.person_id=paf.person_id
270: from per_all_people_f pap,
271: per_all_assignments_f paa,
272: hr_all_organization_units hao,
273: hr_organization_information hoi,
274: per_periods_of_service ppos
275: where pap.person_id =paa.person_id
276: and pap.business_group_id=:l_business_group_id
277: and pap.business_group_id=paa.business_group_id
278: and pap.person_id=nvl(:l_person_id,pap.person_id)
357: hla2.telephone_number_3 COM_ADDRESS
358: from per_all_people_f papf,
359: per_addresses pa,
360: per_all_assignments_f paaf,
361: per_periods_of_service ppos,
362: per_contracts_f pcf,
363: per_collective_agreements pca,
364: hr_all_organization_units hou1,
365: hr_all_organization_units_tl hout1,