DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on PER_ORGANIZATION_UNITS

Line 1242: per_organization_units punits

1238: pop.BUSINESS_GROUP_ID,
1239: punits.name ORGANIZATION_NAME,
1240: pop.availability_status_id
1241: from hr_positions_f pop,
1242: per_organization_units punits
1243: WHERE trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
1244: and pop.organization_id = punits.organization_id
1245: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1246: and not exists