DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1860: , hr_all_organization_units org_unit

1856: , org_unit.organization_id || '_' || substr(org_unit_tl.NAME,1,79 - length(org_unit.organization_id)) user_column_name
1857: , org_unit.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
1858: , org_bg.ORG_INFORMATION9 legislation_code
1859: from hr_organization_information org_Legal_ent
1860: , hr_all_organization_units org_unit
1861: , hr_organization_information org_bg
1862: , hr_all_organization_units_tl org_unit_tl
1863: Where org_Legal_ent.ORG_INFORMATION_CONTEXT = 'CLASS'
1864: And org_Legal_ent.ORG_INFORMATION1 = 'HR_LEGAL'

Line 1862: , hr_all_organization_units_tl org_unit_tl

1858: , org_bg.ORG_INFORMATION9 legislation_code
1859: from hr_organization_information org_Legal_ent
1860: , hr_all_organization_units org_unit
1861: , hr_organization_information org_bg
1862: , hr_all_organization_units_tl org_unit_tl
1863: Where org_Legal_ent.ORG_INFORMATION_CONTEXT = 'CLASS'
1864: And org_Legal_ent.ORG_INFORMATION1 = 'HR_LEGAL'
1865: and org_Legal_ent.ORGANIZATION_ID = org_unit.ORGANIZATION_ID
1866: And org_bg.ORGANIZATION_ID = org_unit.BUSINESS_GROUP_ID