DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on PER_ORGANIZATION_UNITS

Line 1915: per_organization_units punits

1911: pop.BUSINESS_GROUP_ID,
1912: punits.name ORGANIZATION_NAME,
1913: pop.availability_status_id
1914: from hr_positions_f pop,
1915: per_organization_units punits
1916: WHERE pop.business_group_id = g_business_group_id
1917: and trunc(effective_date) between pop.effective_start_DATE and pop.effective_END_DATE
1918: and pop.organization_id = punits.organization_id
1919: and not exists