DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on HR_LOCATIONS

Line 2407: from hr_locations hrl,

2403: substr(hoi.org_information1,1,240)
2404: into l_value1,
2405: l_value2,
2406: l_value3
2407: from hr_locations hrl,
2408: hr_all_organization_units hou,
2409: hr_organization_information hoi
2410: where hou.organization_id = p_tax_unit_id
2411: and hoi.organization_id = hou.organization_id