DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 182: from hr_all_organization_units hou_le,

178: csr_v_legal_employer_id hr_organization_information.organization_id%type
179: ) is
180: select hoi_le.org_information1 local_unit_id, hou_lu.name local_unit_name, hoi_lu.org_information1 local_unit_sd_no,
181: hoi_lu.org_information7
182: from hr_all_organization_units hou_le,
183: hr_organization_information hoi_le,
184: hr_all_organization_units hou_lu,
185: hr_organization_information hoi_lu
186: where hoi_le.organization_id = hou_le.organization_id

Line 184: hr_all_organization_units hou_lu,

180: select hoi_le.org_information1 local_unit_id, hou_lu.name local_unit_name, hoi_lu.org_information1 local_unit_sd_no,
181: hoi_lu.org_information7
182: from hr_all_organization_units hou_le,
183: hr_organization_information hoi_le,
184: hr_all_organization_units hou_lu,
185: hr_organization_information hoi_lu
186: where hoi_le.organization_id = hou_le.organization_id
187: and hou_le.organization_id = csr_v_legal_employer_id
188: and hoi_le.org_information_context = 'FI_LOCAL_UNITS'