APPS.GHR_MLC_PKG dependencies on PER_ORGANIZATION_UNITS
Line 1268: per_organization_units punits
1264: pop.BUSINESS_GROUP_ID,
1265: punits.name ORGANIZATION_NAME,
1266: pop.availability_status_id
1267: from hr_positions_f pop, 1268: per_organization_units punits 1269: WHERE trunc(effective_DATE) between pop.effective_start_DATE and pop.effective_END_DATE
1270: and pop.organization_id = punits.organization_id
1271: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1272: and not exists