DBA Data[Home] [Help]

APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 88: ,hr_locations_all addr

84: ,addr.loc_information16 c_floor
85: ,addr.loc_information17 c_door
86: FROM hr_organization_information hoi
87: ,hr_all_organization_units hou
88: ,hr_locations_all addr
89: ,hr_organization_information hoi1
90: WHERE hou.organization_id = c_business_group_id
91: AND hoi.organization_id = hou.organization_id
92: AND hoi.org_information_context = 'HU_COMPANY_INFORMATION_DETAILS'

Line 403: ,hr_locations_all addr

399: ,pay_input_values_f piv
400: ,pay_element_types_f pet
401: ,pay_element_type_extra_info pei
402: ,hr_organization_units hou
403: ,hr_locations_all addr
404: WHERE pee.element_entry_id = eev.element_entry_id
405: AND eev.input_value_id + 0 = piv.input_value_id
406: AND piv.element_type_id = pet.element_type_id
407: AND pee.assignment_id = c_assignment_id