DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 3909: -- hr_organization_units

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

Line 3913: FROM mtl_system_items msi, hr_organization_units org

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