APPS.OTA_TPS_BUS1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 167: FROM HR_ALL_ORGANIZATION_UNITS

163: l_business_group_id ota_training_plans.business_group_id%TYPE;
164: --
165: CURSOR csr_organization_id IS
166: SELECT business_group_id
167: FROM HR_ALL_ORGANIZATION_UNITS
168: WHERE organization_id = p_organization_id;
169: BEGIN
170: --
171: -- check mandatory parameters have been set