DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 3912: -- hr_organization_units

3908: l_org_id NUMBER;
3909:
3910: -- bug 2492841
3911: -- view org_organization_definitions is changed to base table
3912: -- hr_organization_units
3913:
3914: CURSOR c_org_id is
3915: SELECT org.organization_id
3916: FROM mtl_system_items msi, hr_organization_units org

Line 3916: FROM mtl_system_items msi, hr_organization_units org

3912: -- hr_organization_units
3913:
3914: CURSOR c_org_id is
3915: SELECT org.organization_id
3916: FROM mtl_system_items msi, hr_organization_units org
3917: WHERE msi.inventory_item_id = p_qte_line_rec.inventory_item_id
3918: AND org.organization_id= msi.organization_id
3919: AND sysdate <= nvl( org.date_to, sysdate)
3920: AND org.organization_id= p_shipment_rec.ship_from_org_id