DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on HR_LOCATIONS

Line 2217: from hr_locations hrl,

2213: substr(hoi.org_information1,1,240)
2214: into l_value1,
2215: l_value2,
2216: l_value3
2217: from hr_locations hrl,
2218: hr_all_organization_units hou,
2219: hr_organization_information hoi
2220: where hou.organization_id = p_tax_unit_id
2221: and hoi.organization_id = hou.organization_id