DBA Data[Home] [Help]

APPS.OTA_FR_TRG_SUM dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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 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'