DBA Data[Home] [Help]

APPS.OTA_FR_TRG_SUM dependencies on HR_ORGANIZATION_INFORMATION

Line 273: hr_organization_information hoi,

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
277: and pap.business_group_id=paa.business_group_id

Line 367: hr_organization_information hoi1,

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,
370: hr_locations_all hla2
371: where papf.person_id=l_p_person_id