DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on HR_POSITIONS_F

Line 1914: from hr_positions_f pop,

1910: pop.ORGANIZATION_ID,
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