DBA Data[Home] [Help]

APPS.IEX_PAYMENT_COLL_RPT_PKG dependencies on HR_OPERATING_UNITS

Line 143: from hr_operating_units

139: if p_org_id is not null then
140: l_where:=l_where||' and d.org_id='||p_org_id;
141: select name
142: into l_org_id
143: from hr_operating_units
144: where organization_id=p_org_id;
145: else
146: l_org_id:='All';
147: end if;