DBA Data[Home] [Help]

APPS.OTA_FR_TRG_SUM dependencies on HR_LOCATIONS_ALL

Line 366: hr_locations_all hla1,

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,
370: hr_locations_all hla2

Line 370: hr_locations_all hla2

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'
374: and pa.business_group_id(+)=papf.business_group_id