DBA Data[Home] [Help]

APPS.PER_FR_BIAF_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 63: hr_all_organization_units_tl hout,

59: ppos.actual_termination_date actual_termination_date
60: from
61: hr_locations_all hla,
62: hr_all_organization_units hou,
63: hr_all_organization_units_tl hout,
64: per_all_assignments_f paf ,
65: per_all_people_f apf,
66: per_addresses pav,
67: hr_organization_information hoi,

Line 116: hr_all_organization_units_tl hrvt,

112: hla.telephone_number_2 Fax,
113: hla.telephone_number_3 Telephone3
114: from hr_organization_information hoi,
115: hr_all_organization_units hrv,
116: hr_all_organization_units_tl hrvt,
117: hr_locations_all hla
118: where hoi.ORG_INFORMATION_CONTEXT='CLASS'
119: and hoi.org_information1='FR_OPAC'
120: and hrv.business_group_id=l_bg_id