DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4765: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

4761: ,x_msg_count OUT NOCOPY NUMBER) IS
4762:
4763: cursor location_shipping_method_count(c_from_org_id number, c_to_location_id number) IS
4764: SELECT count(*)
4765: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
4766: where hao.organization_id = c_from_org_id
4767: and ism.from_location_id = hao.location_id
4768: and ism.to_location_id = c_to_location_id;
4769:

Line 7581: from HR_ALL_ORGANIZATION_UNITS

7577: and lookup_code = l_item_type;
7578:
7579: CURSOR get_location_id(c_org_id NUMBER) IS
7580: select location_id
7581: from HR_ALL_ORGANIZATION_UNITS
7582: where organization_id = c_org_id;
7583:
7584: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
7585: select CONCATENATED_SEGMENTS