APPS.OTA_FR_TRG_SUM dependencies on HR_ALL_ORGANIZATION_UNITS

Line 272: hr_all_organization_units hao,

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

Line 364: hr_all_organization_units hou1,

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,

Line 365: hr_all_organization_units_tl hout1,

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,

Line 368: hr_all_organization_units hou2,

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

Line 369: hr_all_organization_units_tl hout2,

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'