APPS.CSM_EMAIL_QUERY_PKG dependencies on CSP_SEC_INVENTORIES

Line 2674: csp_sec_inventories csi

2670: CURSOR c_get_sub_inv(p_resource_id NUMBER, p_org_id NUMBER)
2671: IS
2672: SELECT ila.SUBINVENTORY_CODE , csi.condition_type
2673: FROM CSP_INV_LOC_ASSIGNMENTS ila,
2674: csp_sec_inventories csi
2675: WHERE ila.RESOURCE_ID = p_resource_id
2676: AND ila.RESOURCE_TYPE = 'RS_EMPLOYEE'
2677: AND ila.ORGANIZATION_ID = p_org_id
2678: AND csi.secondary_inventory_name = ila.subinventory_code