268: open c_ref_cur for
269: 'Select DISTINCT pap.person_id person_id,pap.employee_number employee_number,pap.full_name full_name
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
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,
366: hr_locations_all hla1,
367: hr_organization_information hoi1,
368: hr_all_organization_units hou2,
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,
366: hr_locations_all hla1,
367: hr_organization_information hoi1,
368: hr_all_organization_units hou2,
369: hr_all_organization_units_tl hout2,
364: hr_all_organization_units hou1,
365: hr_all_organization_units_tl hout1,
366: hr_locations_all hla1,
367: hr_organization_information hoi1,
368: hr_all_organization_units hou2,
369: hr_all_organization_units_tl hout2,
370: hr_locations_all hla2
371: where papf.person_id=l_p_person_id
372: and pa.person_id(+)=papf.person_id
365: hr_all_organization_units_tl hout1,
366: hr_locations_all hla1,
367: hr_organization_information hoi1,
368: hr_all_organization_units hou2,
369: hr_all_organization_units_tl hout2,
370: hr_locations_all hla2
371: where papf.person_id=l_p_person_id
372: and pa.person_id(+)=papf.person_id
373: and pa.primary_flag(+)='Y'