APPS.PV_REFERRAL_COMP_PUB dependencies on HR_ORGANIZATION_UNITS

Line 805: FROM hr_organization_units

801: -- Display the org_id and the operating unit that the claim is
802: -- created in.
803: -- -----------------------------------------------------------------
804: FOR z IN (SELECT name
805: FROM hr_organization_units
806: WHERE organization_id = l_claim_rec.org_id)
807: LOOP
808: l_operating_unit := z.name;
809: END LOOP;