DBA Data[Home] [Help]

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